Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle doesn't like INNER JOIN 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]
Hi
Oracle doesn't know the syntax with INNER JOINS. The OUTER JOIN is done
via (+).
I think you have to do something like :
Select x, y
from table1 a, table2 b
where a.z = b.z
( all x and y values for records existing in table1 and table2)
HtH
eugen
Received on Wed Feb 18 1998 - 00:00:00 CST