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