Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What does this mean: Outer Join (+) on a Value?

Re: What does this mean: Outer Join (+) on a Value?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 09 Jan 2004 19:43:03 +0100
Message-ID: <kgttvvc0hp8b63o5a11j4pa1151ogium3g@4ax.com>


On 9 Jan 2004 10:11:22 -0800, Spam_at_DefinitiveSolutions.com (Larry Leonard) wrote:

>Aren't the second and third occurances of (+) unnecessary (or even
>meaningless)?

They are necessary.
Otherwise you will have an ambiguous inner join

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jan 09 2004 - 12:43:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US