这样的查询如何实现?

gokong

现有两个结构一样的表,数据如下:


表A

















ID





编号1








1





10








3





12








4





8








6





20


表B

















ID





编号2








2





10








4





8








5





13








6





25








8





18


现想建立一个查询,查询的结果如下:

















ID





编号1





编号2








1





10














2











10








3





12














4





8





8








5











<FONT face="Ti

glw

用联合查询,然后汇总一下用SUM

[此贴子已经被作者于2006-1-14 16:10:07编辑过]

gokong

谢谢.能否给个sql代码,非常感谢.

wwwwa

try:
SELECT a.id, d1, d2, d3
FROM (([select id from tb union select id from ts union select id from tg]. AS a LEFT JOIN [select id,sum(day1) as d1 from tb group by id]. AS b ON a.id=b.id) LEFT JOIN [select id,sum(day2) as d2 from ts group by id]. AS c ON a.id=c.id) LEFT JOIN [select id,sum(day3) as d3 from tg group by id]. AS d ON a.id=d.id;