Re: multiple "left outer join"

From: Justin Cave <jocave_at_yahoo.com>
Date: 12 Sep 2001 10:20:31 -0700
Message-ID: <233b7a65.0109120920.5c0da42b@posting.google.com>

Luca Saccarola <l.saccarola_at_bigfoot.com> wrote in message news:<Pine.WNT.4.33.0109101244430.1068-100000_at_w-saccarol>...
>
> 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

Are you using the SQL-92 syntax directly or are you using the ODBC version (i.e. {oj SQL-92 join})? If the former, the other reply is correct-- Oracle doesn't support it. If the latter, the ODBC driver should mangle your call into the appropriate call using Oracle syntax.

Please make sure that you have the latest Oracle ODBC driver if you're going to be using the {oj } syntax.

Justin Cave Received on Wed Sep 12 2001 - 12:20:31 CDT