Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Questions regarding MS ACCESS, ODBC and ORACLE

Re: Questions regarding MS ACCESS, ODBC and ORACLE

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/11/29
Message-ID: <bJdvMGAT0snyEwLt@jimsmith.demon.co.uk>#1/1

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
Received on Fri Nov 29 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US