22,300
社区成员




select a.ID,SUM(a.QUAN1) QUAN1,SUM(b.QUAN2) QUAN2
from table1 a
join table2 b on a.ID=b.ID
group by a.ID
select a.ID,a.QUAN1,b.QUAN2
from (select ID,QUAN1=sum(QUAN1) from table1 group by ID) a,
(select ID,QUAN2=sum(QUAN2) from table2 group by ID) b
where a.ID=b.ID