Re: inner joins not working in oracle!!!

No, that doesn't work either. It still says "SQL command not ended properly." I am a bit suspicious that it didn't say "error: bad syntax" or something, but I find that Oracle's messages tend to be a bit wierd sometimes anyway. I starting to think that Roberto's comment might be true...inner joins aren't ansi sql. I was sure they were, but apparently not. ----- Original Message ----- From: Michael Howitz <mac@gmx.net> To: php-db <php-db@lists.php.net> Sent: Wednesday, September 06, 2000 7:46 PM Subject: Re: [PHP-DB] inner joins not working in oracle!!! > hi, > > have you tried to tell oracle the colums on which the join should take > place? > > e.g.: > "select level1.level1_id, page_title from level1 inner join page > ON level1.pid = page.id > order by level1_sort" > > (the name of the keys are badly guessed) > > by, > mac > > Tyson Lloyd Thwaites wrote: > > > > 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 > > -- > 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 > >