Re: Oracle doesn't like INNER JOIN syntax

I thought that it was the SQL92 syntax.

On Wed, 18 Feb 1998 21:04:52 GMT, Quinton McCombs <quintonm_at_bellsouth.net> wrote:

>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]
>

Kaboel Karso Received on Thu Feb 19 1998 - 00:00:00 CST