17,086
社区成员
发帖
与我相关
我的任务
分享
select A.aa,A.bb,A.cc,sum(nvl(B.dd,0))
from A
left join B on A.aa=b.aa and A.bb=b.bb and A.cc=B.cc
group by A.aa,A.bb,A.cc
select A.aa,A.bb,A.cc,sum(nvl(B.dd,0))
from A,B
where A.aa=b.aa(+) and A.bb=b.bb(+) and A.cc=B.cc(+)
group by A.aa,A.bb,A.cc