Re: Outer join by (+)
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 29 Dec 2007 11:13:36 +0100
Message-ID: <5tmkuiF1ehehqU1@mid.individual.net>
>
> Thanks for your replay
>
> because it is very difficult to design
> for example
>
> select ...
> from
> Table1 left outer join Table2 left outer join Table4 left outer join
> Table5 on (Table4.Col3= Table5.Col3) left outer join Table6
> (Table4.Col3= Table6.Col3) on (Table2.Col2= Table4.Col2) on
> (Table1.Col1= Table2.Col1)
> left outer join Table3 on (Table1.Col1= Table3.Col1)
>
> can you understand this???
Date: Sat, 29 Dec 2007 11:13:36 +0100
Message-ID: <5tmkuiF1ehehqU1@mid.individual.net>
On 29.12.2007 09:35, nova1427_at_gmail.com wrote:
> On Dec 27, 7:16 pm, Tonkuma <tonk..._at_fiberbit.net> wrote:
>> On Dec 26, 3:50 pm, nova1..._at_gmail.com wrote:
>>
>>
>>
>>> to make outer join in this case like
>>> table2.column2(+) = 'AAAA'
>>> what about this
>>> table2.column2 in ('AAAA', 'BBB')
>>> I want also outer join
>> Why you don't want to use the OUTER JOIN syntax as Robert suggested.
>
> Thanks for your replay
>
> because it is very difficult to design
> for example
>
> select ...
> from
> Table1 left outer join Table2 left outer join Table4 left outer join
> Table5 on (Table4.Col3= Table5.Col3) left outer join Table6
> (Table4.Col3= Table6.Col3) on (Table2.Col2= Table4.Col2) on
> (Table1.Col1= Table2.Col1)
> left outer join Table3 on (Table1.Col1= Table3.Col1)
>
> can you understand this???
Easier than with the (+) syntax. Btw, a little formatting goes a long way to make this readable.
> But when I use (+) syntax, it will be easy to design and understand.
Well, apparently YMV but I prefer the ANSI syntax because of readability and expressiveness.
Kind regards
robert Received on Sat Dec 29 2007 - 04:13:36 CST