select id1,id2 ,sum(a.field1+b.field2)
from A a, B b where a.id1=b.id1 and a.id2=b.id2 <-select b.id1,b.id2 ,sum(a.field1+b.field2)
from (select sum(field1) as field1 , id1, id2 from A
group by id1,id2 ) a, B b
where a.id1=b.id1 and a.id2=b.id2
from A a, B b where a.id1=b.id1 and a.id2=b.id2 <-select b.id1,b.id2 ,sum(a.field1+b.field2)
from (select sum(field1) as field1 , id1, id2 from A
group by id1,id2 ) a, B b
where a.id1=b.id1 and a.id2=b.id2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货