Whats the Oracle9i Full OUTER JOIN syntax

[PTCruiserII]

Does anyone know the Oracle 9i FULL OUTER JOIN syntax and also how can I simulate this FULL Outer JOIN in ORACLE8i.

Would I use something like:

Select ... Where a.f1=b.f1(+) or a.f1(+)=b.f1

or would a UNION work

Select ... Where a.f1=b.f1(+) UNION
Select ... where a.f1(+)=b.f1

Any gurus out there?

 

[carp]

Don't know about 9i, but the UNION approach will work.

 

[PTCruiserII]

Thanks Carp

So with the union, I guess any group by or order by will be placed at the end of the whole statement?