สอบถามเกี่ยวกับการจอย ตาราง 3ตาราง รบกวนช่วยแนะนำทีครับ

SELECT *
FROM Table1 a
FULL JOIN Table2 b ON (a.Username=b.Username)
FULL JOIN Table3 c ON (a.Username=c.Username)

DECLARE @PODT TABLE (JobNo VARCHAR(1), PartNo VARCHAR(1), Cost INT)
DECLARE @ISDT TABLE (JobNo VARCHAR(1), PartNo VARCHAR(1), Cost INT)

INSERT INTO @PODT VALUES ('a', N'ก', 1), ('a', N'ข', 2), ('a', N'ค', 3)
INSERT INTO @ISDT VALUES ('a', N'ก', 1), ('a', N'ข', 2), ('a', 'ง', 4), ('a', N'ค', 3)



;WITH PODT
AS (
	SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)
			) aN, sys.fn_PhysLocFormatter (%%physloc%%) AS [Fuck a]
			        
	FROM @PODT
	)
, ISDT
AS (
	SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)
			) bN, sys.fn_PhysLocFormatter (%%physloc%%) AS [Fuck b]
	FROM @ISDT
	)
SELECT *
FROM PODT
FULL JOIN ISDT ON PODT.aN = ISDT.bN
--WHERE (PODT.JobNo = 'a' OR ISDT.JobNo = 'a')

  select *
  --,A.[JobNo],B.[JobNo] 
from(
    SELECT [JobNo],[PartNo],row_number() over (order by Cost) as row_num
    FROM [ISDT])A
full join
    (SELECT [JobNo],[PartNo],row_number() over (order by Cost) as row_num
    FROM [PODT])B
on  A.row_num=B.row_num
WHERE (a.JobNo = 'a' OR b.JobNo = 'a')
ORDER BY A.[PartNo],B.[PartNo]