Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: FULL JOIN syntax vs (+)
Jonathan Lewis wrote:
> 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
Is that a typo? Should it be "b,a" instead of "b,1"?
Regards,
Dave
> 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.