SELECT *
FROM T1
FULL OUTER JOIN T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID
T1对应T2中有两条记录,如何合并T2中的字段,比如合并数量?
------解决思路----------------------
SELECT *
FROM T1
inner join T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID
------解决思路----------------------
SELECT *
FROM T1
lefter outer join T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID