Re: Oracle + ODBC Outer Joins + Drivers

"Charles Gamble" <Charles.Gamble_at_Singularity.co.uk> wrote in message news:ATIv5.17857$8r4.176965_at_news2-win.server.ntlworld.com...
> Hi all,
>
> I am having a problem when using the ODBC {oj} Outer Join escape sequence
> with Oracle ODBC drivers. When I use the current Oracle ODBC driver from
> Oracle everything works fine. However, when I use the current Microsoft
> Oracle ODBC driver I get problems when doing outer joins with more than
 one
> table. (I am doing the JOINs using primary key fields).

Hi I'm not sure if this is exactly the case but your queries would probably be better rewritten using the (+) operator. This would be the Oracle standard way of doing an outer join.

regards & HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK