Re: FULL JOIN syntax vs (+)

Domenic G. wrote:

>Is there a way to simulate a two-way outer join using (+) ...
>
>ie.
>
>select a.*, b.* from a full join b on a.whatever = b.whatever;
>
>Can I do this without the "FULL JOIN" syntax in 9i using just (+)??
>
>Dom.
>
>

I often use the method Jonathan describes but quite often I prefer selecting from in-line
views, each of which contain an outer join. Doing it with in-line views also allows for the
creation of multiple OUTER JOINs of any type.

-- 

Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)