Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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