R: [PHP-DB] inner joins not working in oracle!!!

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 >