Re: inner joins not working in oracle!!!

I was sure it was ANSI: I've used inner joins in other DBs, not just access. For example we use Sybase and it supports inner joins. But they're not in the Oracle help files, so maybe they're just a common extension. Wow...I thought inner joins were basic to any SQL dialect! That's Access Stuff!!! Use Standard SQL 92 with Oracle, not Access "extensions": "select level1.level1_id, page_title from level1, page where level1.<field>=page.<field> order by level1_sort" Ciao Roberto > -----Messaggio originale----- > Da: Tyson Lloyd Thwaites [mailto:tysonlt@webmedia.com.au] > Inviato: mercoledì 6 settembre 2000 8.43 > A: php-db > Oggetto: [PHP-DB] inner joins not working in oracle!!! > > > Hi guys, > > I can't get oracle to perform inner joins!!! It says > "SQL command not properly ended." > > What's going on here? I can't even get it to work in SQL*Plus. > Here's the string: > "select level1.level1_id, page_title from level1 inner join > page order by > level1_sort" > > It's not the order by, I tried taking that out. The query > does work if you > take the inner join > out, so Oracle is working. All the foreign keys are set up > properly. It's > got all of us baffled. > > Would it help to use OCI not odbc? Shouldn't matter since it > doesn't even > work in SQLPlus, though. > > BTW, does anyone know where to get php_oci8.dll? > > Thanks > > Regards, > > Tyson Lloyd Thwaites > IT&e Ltd > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >