Re: Oracle 8i SQL Problem..

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:

Hi, 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