Re: Questions regarding MS ACCESS, ODBC and ORACLE

In article <3299D880.1854_at_cincom.com>, "Brian M. Biggs"
>
>We have a large Access application that has been ported to Oracle, and
>we have had very few problems. Most of the application works, except
>for several queries involving left joins.
>

Oracle does not support any of the 'explicit join' syntax of SQL-92/ This includes LEFT JOIN, INNER JOIN, OUTER JOIN etc.

You will need to recode your queries using Oracle's syntaz.

-- 
Jim Smith