oracle 多列求和

select B.AA, B.BB, C.CC from (select 表1.AA, sum(表1.BB) cntBB from 表1 group by 表1.AA) B, (select 表2.AA, sum(表2.CC) cntCC from 表2 group by 表2.AA) C where B.AA=C.AA and B.cntBB C.cntCC