Re: FULL JOIN syntax vs (+)

I think this is the correct starting point:

select {list of column}
from

        a, b
where

        b.id(+) = a.id -- preserve A union all
select {list of columns}
from

        b,1
where

        a.id(+) = b.id        -- preserve B
and    a.id is null            -- discard inner join result

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Belgium__November (EOUG event - "Troubleshooting")
____UK_______December (UKOUG conference - "CBO")


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Domenic G." <domenicg_at_hotmail.com> wrote in message
news:c7e08a19.0311121242.46df9b3d_at_posting.google.com...


> 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.