27,579
社区成员
发帖
与我相关
我的任务
分享
select pid, bid, pno, Anum+Bnum
from (select pid, bid, pno, sum(pNum) Anum from A group by pid, bid, pno) as tab1
left join (select pid, bid, pno, sum(pNum) Bnum from B group by pid, bid, pno) as tab2
on tab1.pid=tab2.pid and tab1.bid=tab2.pid and tab1.pno=tab2.pno