A表 B表
a b c c d e
a c d c d f
e f g
--------------------------------------------
希望得到结果:
a b c d e
a b c d f
a c d null null
null null e f g
a b c c d e
a c d c d f
e f g
--------------------------------------------
希望得到结果:
a b c d e
a b c d f
a c d null null
null null e f g
FROM A A FULL OUTER JOIN B B ON A.C = B.C
a b c
a c dB表
c d e
c d f
e f g
--------------------------------------------
希望得到结果:
a b c d e
a b c d f
a c d null null
null null e f g
Aid | Aname | Acode
a | b | c
a | c | dB表
Bcode | Bname | Bid
c | d | e
c | d | f
e | f | g
--------------------------------------------
希望得到结果:
Aid | Aname | code | Bname | Bid
a | b | c | d | e
a | b | c | d | f
a | c | d | null | null
null | null | e | f | g
with A as (
select 'A' aid, 'B' aname, 'C' acode from dual union all
select 'A' aid, 'C' aname, 'D' acode from dual ),
B as (
select 'C' bcode, 'D' bname, 'E' bid from dual union all
select 'C' bcode, 'D' bname, 'F' bid from dual union all
select 'E' bcode, 'F' bname, 'G' bid from dual )select aid,aname,acode code,bname,bid from A,B where a.acode = b.bcode(+)
union
select '','',bcode,bname,bid from B where bcode not in (select acode from A);