INNER JOIN syntax not supported?

From: Roal Zanazzi <roal.zanazzi_at_sefin.com>
Date: 2000/06/06
Message-ID: <8histr$n30$1@lacerta.tiscalinet.it>#1/1

Hi everyone,

I'm porting an Access database to Oracle 8i (8.1.5). On the client side (a Visual Basic application with MS ADO library) I've a bunch o queries with INNER JOIN between 2 (or more) tables. An example of such queries is:
SELECT * FROM table1 INNER JOIN table2 ON table1.id1 = table2.id2;

If I run this query in SQL*PLUS it gives me the following error: ORA-00933: SQL command not properly ended on the J of JOIN.

This is standard SQL syntax (ISO and, afaik, ANSI), but Oracle doesn't support it.
Is this true? (on-line manual says nothing about INNER...)

Am I going to change _every_ query containing the new JOIN syntax?

Roal Zanazzi Received on Tue Jun 06 2000 - 00:00:00 CDT