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

Home -> Community -> Usenet -> c.d.o.server -> Re: INNER JOIN syntax not supported?

Re: INNER JOIN syntax not supported?

From: Markus Schwabe <mschwabe_at_gscout.de>
Date: 2000/06/06
Message-ID: <8hj0e6$jb$1@news4.muc.eurocyber.net>#1/1

Replace INNER JOIN with a Comma (,), ON with WHERE: SELECT * FROM table1, table2 WHERE table1.id1 = table2.id2; Sorry, but I think you have to change...

Hth
Markus

Roal Zanazzi <roal.zanazzi_at_sefin.com> schrieb in im Newsbeitrag: 8histr$n30$1_at_lacerta.tiscalinet.it...
> 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

Original text of this message

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