Outer join bug in Oracle?

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 - 12:52:46 CDT