3,491
社区成员
发帖
与我相关
我的任务
分享
with taba as
(
select 1 a,5 b from dual union all
select 2,8 from dual union all
select 3,9 from dual ),
tabb as
(
select 2 a,10 b from dual union all
select 3,4 from dual union all
select 4,5 from dual
)
select nvl(taba.a, tabb.a), taba.b, tabb.b
from taba
full join tabb
on (taba.a = tabb.a)
order by nvl(taba.a, tabb.a)