Re: Outer join by (+)
Date: Sat, 29 Dec 2007 11:13:36 +0100
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 ...
> 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.
robert Received on Sat Dec 29 2007 - 04:13:36 CST