多表联查数据合并的实现，求指教

[飞扬的雪花]

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 id,sum(isnull(data1,0)) data1,sum(isnull(data2,0)) data2 from 表1 group by id

[shoppo0505]

SELECT * FROM T1 inner join T2 ON T1.ID = T2.ID FULL OUTER JOIN T3 ON T1.ID = T3.ID

[shoppo0505]

引用 2 楼 shoppo0505 的回复:

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