34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM T1
FULL OUTER JOIN ( SELECT ID, SUM(数量)数量
FROM T2
GROUP BY ID
) T2S ON T1.ID = TS.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID
SELECT *
FROM T1
FULL OUTER JOIN T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID
SELECT T1.ID,T2.ID,T3.ID
FROM #T1 T1
INNER JOIN #T2 T2 ON T1.ID = T2.ID
INNER JOIN #T3 T3 ON T1.ID = T3.ID
WHERE ....