17,377
社区成员
发帖
与我相关
我的任务
分享
with a as (
select '1' id,7 num from dual
union all
select '2' id,8 num from dual
),
b as (
select '1' id,9 num from dual
union all
select '3' id,10 num from dual
),
c as (
select '1' id,'AA' na from dual
union all
select '2' id,'BB' na from dual
union all
select '3' id,'CC' na from dual
)
select c.na,nvl(a.num,0),nvl(b.num,0)
from a,b,c
where a.id(+) = c.id
and b.id(+) = c.id