FULL OUTER JOIN

[cgi]

is that someone know how to make a full outer join with oracle ?

------------------
Christian Gincheleau

 

[Vents Lauva]

This can be done with union (example from scott schema)

select a.*,b.* from emp a, dept b where a.deptno(+) = b.deptno
union
select a.*,b.* from emp a, dept b where a.deptno = b.deptno(+);

Vents Lauva
Member