Re: outer joins

That's only a left (or right) outer join. The only way right now to do a full (symmetric) outer join in Oracle is to do a left-outer UNION the right-outer!

It's no pretty, but it's a living! ;^)

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216

In article dmr_at_zippy.cais.net, randyd_at_cais3.cais.com (Randy Dewoolfson) writes:
>Yoo-Shin Lee (yoosh_at_cs.ualberta.ca) wrote:
>: Hi,
 

>: anyone know of any way to do an outer join (full) in oracle?
>
>
>: --
>: Yoo-Shin Lee
>: yoosh_at_cs.ualberta.ca
>: http://web.cs.ualberta.ca/~yoosh
>
>
>add the (+) operator on the column you wish to be considered inclusively
>
>--
> ..uu. ----------------------
> .?$" '?i . I Randy DeWoolfson I
> .T^M ._at_" d9 . f ,.un. b, i I--------------------I
> " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I
> &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I
> ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I
> & 'M ,P `E M "$ Mux~ n!` I |o o| I
> dk `h" ' j " y" *~ I====oOO==(_)==Ooo===I
>
Received on Mon Nov 27 1995 - 00:00:00 CET