我有两张表
a: id(char) ,qt1(int)
b: id(char), qt2(int)
其中a.id=b.id
数据分别类似以下
a:
id qt1
a 10
b 20
b 30
b:
id qt2
a 40
a 50
b 60
现在我想要根据id统计每个a或b的qt1和qt2
结果要的是
id qt1 qt2
a 10 90
b 50 60
如何实现呀
a: id(char) ,qt1(int)
b: id(char), qt2(int)
其中a.id=b.id
数据分别类似以下
a:
id qt1
a 10
b 20
b 30
b:
id qt2
a 40
a 50
b 60
现在我想要根据id统计每个a或b的qt1和qt2
结果要的是
id qt1 qt2
a 10 90
b 50 60
如何实现呀
就差100 分就升级,多给点吧
这个是对的!其他的出来的结果和你的不一样!
from
(select id, sum(qt1) as qt1 from a group by id) as a join
(select id, sum(qt2) as qt2 from b group by id) as b on
a.id = b.id
from
(select id, sum(qt1) as qt1 from a group by id) as a join
(select id, sum(qt2) as qt2 from b group by id) as b on
a.id = b.id正解。