这样写SELECT ISNULL(T1.TRN_NO, T2.TRN_NO), …… FROM T1 LEFT JOIN T2 ON ……
完善一下SELECT ISNULL(T2.TRN_NO, T1.TRN_NO) AS TRN_NO, ...... FROM T2 LEFT JOIN T1 ON ......
SELECT B.TRN_NO,B.MAK_ID,B.FCT_ID,B.SEW_DR,B.GRP_ID,B.SEC_ID,B.SEC_NM,B.CUS_ID,B.BUY_ID,B.STY_NO,B.ORD_NO,MTX_NO,B.REF_NO,B.REF_N1,B.COL_NO,B.COL_NM, B.SIZ_SQ,A.SIZ_NM,ISNULL(B.QTY_01,0) QTY_01,ISNULL(B.QTY_02,0) QTY_02,ISNULL(B.QTY_03,0) QTY_03,ISNULL(B.QTY_09,0) QTY_09,ISNULL(B.PRD_QT,0) PRD_QT --INTO #A FROM #T2 A LEFT JOIN #R B ON A.TRN_NO=B.TRN_NO AND A.SIZ_NM=B.SIZ_NM
FROM T1 LEFT JOIN T2 ON ……
FROM T2 LEFT JOIN T1 ON ......
B.SIZ_SQ,A.SIZ_NM,ISNULL(B.QTY_01,0) QTY_01,ISNULL(B.QTY_02,0) QTY_02,ISNULL(B.QTY_03,0) QTY_03,ISNULL(B.QTY_09,0) QTY_09,ISNULL(B.PRD_QT,0) PRD_QT
--INTO #A
FROM #T2 A
LEFT JOIN #R B ON A.TRN_NO=B.TRN_NO AND A.SIZ_NM=B.SIZ_NM