Re: Outer join by (+)
Date: Sat, 29 Dec 2007 00:35:54 -0800 (PST)
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
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