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

Home -> Community -> Usenet -> c.d.o.server -> Re: outer join question

Re: outer join question

From: pmd <PMD_at_SIBU.HQ>
Date: Mon, 20 Aug 2007 18:07:16 +0100
Message-ID: <facho8$ljc$1@registered.motzarella.org>


Serge Rielau wrote:
> matt lewis wrote:
>

>> Placing e to the left of d in the first and to the right in the second 
>> does not produce any difference. What am I doing wrong here?

>
> Nothing. In the (+) notation the semantics is defined in the positioning
> of the (+), not in the order of the table references.
> To flip the join you need to flip the (+) to the other table's column.
>
> Cheers
> Serge

Thanks Serge. Received on Mon Aug 20 2007 - 12:07:16 CDT

Original text of this message

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