Re: Outer join bug in Oracle?

Actually you can change this to:
select * from
(

   (select oj1.c1 from oj1 left outer join oj2 on oj1.c1=oj2.c1 ) t1     left outer join
   (select oj2.c1 from oj2 left outer join oj1 on oj1.c2=oj2.c2) t2    on t1.c1=t2.c1
)

It wont make a difference, but the query is more cleaner now. Thanks
Aakash

"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message news:cck1fo$dju$1_at_hanover.torolab.ibm.com...
> Hi , I am trying this on v91. Is this a known issue?
>
> select * from
> (
> (select * from oj1 left outer join oj2 on oj1.c1=oj2.c1 ) t1
> left outer join
> (select * from oj2 left outer join oj1 on oj1.c2=oj2.c2) t2
> on t1.c1=t2.c1
> )
>
> I get the following error:
> Associated text and tokens are "ORA-00907: missing right parenthesis ".
>
> I am not sure what I am doing wrong. Any clues?
>
> Thanks
> Aakash
>
>
Received on Thu Jul 08 2004 - 13:48:07 CDT