Re: Why join conditions mandatory for outer joins ?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 30 Aug 2003 20:42:38 +1000
Message-ID: <3f507fb1$0$14558$afc38c87@news.optusnet.com.au>

because in the traditional Oracle syntax you *have* to use a join condition to indicate an outer join.

Not anymore if you use the ANSI syntax in 9i.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"qazmlp" <qazmlp1209_at_rediffmail.com> wrote in message news:db9bbf31.0308300205.7ede61b9_at_posting.google.com...


> What is the reason for making the join conditions as mandatory for

> outer joins but optional for inner joins ?

Received on Sat Aug 30 2003 - 05:42:38 CDT