I could be wrong on this but I believe that Oracle 8i uses a proprietary 
join syntax.  This support has been added in the latest version of Oracle, 
but with 8i I believe you're out of luck using the left join keywords.

Check out 
http://certcities.com/certs/oracle/columns/story.asp?EditorialsID=106 for 
more info on this.

At 10:26 AM 7/28/2002 -0500, Frank S. Kicenko wrote:
>This really isn't a PHP issue..sorry.
>I'm having a nightmare with Oracle 8i (pos!). I'm writing common SQL
>which works for MSSQL 2K and seems correct for Oracle... but keeps
>giving me a Error.. ORA-00933 SQL command not properly ended on the
>following query...
>SELECT grp.grpdescrip, grp.grp, grp.createcust, grp.auth1, grp.auth2,
>usergrp.userid, users.userdescrip
>                         FROM grp
>                         LEFT JOIN usergrp
>                         ON grp.grp=usergrp.grp
>                         LEFT JOIN users
>                         ON usergrp.userid=users.userid
>                         ORDER BY grp.grp
>The error keeps pointing at the first "LEFT JOIN". Anybody know why?
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to