Re: Oracle doesn't like INNER JOIN syntax

INNER should be removed. 'INNER JOIN' is MS Access syntax.

Randy Baker wrote:
>
> (reposted since it appeared to get lost on first attempt)
>
> I get error ORA-0933 ("SQL command not ended properly") when I execute a
> query in the form "SELECT x, y from Table1 INNER JOIN Table2 ON Table1.z =
> Table2.z", where x, y, and z are field names. SQL Server and Access support
> this join syntax without any problems.
>
> Am I missing something or are we going to have to do rewrite all our join
> queries (or at the very least preprocess them) in order to migrate to
> Oracle? Anyone know of a good SQL parser that might help with this task? We
> are trying to maintain a single code base, but this looks like it might make
> this more or less impossible.
>
> --
> Randy Baker (remove Z from address in email replies)
>
> [Image]
Received on Wed Feb 18 1998 - 00:00:00 CST