Re: multiple "left outer join"

Hi,

"Luca Saccarola" <l.saccarola_at_bigfoot.com> wrote in message news:Pine.WNT.4.33.0109101244430.1068-100000_at_w-saccarol...

> Hi All,
>
> I'm accessing an Oracle DBMS (v8.0.4.0.0) on UnixWare 7.0.1 from a
> Windows NT client through Oracle ODBC driver . It's fine but, while
> creating a view containing multiple "left outer join" using SQL-92 syntax,
> I've got an ORA-933 error. Any tips ? TIA
>
> Regards.

Oracle versions under 9 doesn't support 'LEFT/RIGHT/FULL OUTER JOIN' syntax. In Oracle use the (+) syntax, i.e

select a.c1,a.c2,b.c1,b.c2 from tab1 a, tab2 b where a.c1=b.c1(+) and a.c2=b.c2(+)
is equivalent to
select a.c1,a.c2,b.c1,b.c2 from tab1 a left outer join tab2 b on a.c1=b.c1 and a.c2=b.c2
You got a real ORA- error, so I suppose you made a pass through query. When you use pure odbc (i.e M$Access) you can use the left outer join syntax.

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG