Re: Outer join by (+)

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???

But when I use (+) syntax, it will be easy to design and understand. Received on Sat Dec 29 2007 - 02:35:54 CST