with a1 as
(select 1 as id, 45 as nu
from dual
union all
select 2 as id, 46 as nu
from dual
union all
select 3 as id, 47 as nu
from dual
union all
select 4 as id, 48 as nu from dual),
a2 as
(select 1 as id, 45 as nu
from dual
union all
select 5 as id, 57 as nu
from dual
union all
select 6 as id, 98 as nu from dual)select nvl(a1.id, a2.id), a1.nu, a2.nu
from a1
full join a2
on a1.id = a2.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货