Re: 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