RE: [PHP] Oracle 8i SQL Problem..
Oracle 9i would be happy with the left join syntax but not 8i. -Original Message- From: Martin Towell [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:09 AM To: 'Nick Oostveen'; Frank S. Kicenko; [EMAIL PROTECTED] Subject: RE: [PHP] Oracle 8i SQL Problem.. You'll prob. need to use the (+) to join like this SELECT grp.grpdescrip, grp.grp, grp.createcust, grp.auth1, grp.auth2, usergrp.userid, users.userdescrip FROM grp, usergrp, users WHERE grp.grp = usergrp.grp (+) AND usergrp.userid=users.userid (+) ORDER BY grp.grp -Original Message- From: Nick Oostveen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:47 PM To: Frank S. Kicenko; [EMAIL PROTECTED] Subject: Re: [PHP] 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 -- 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Oracle 8i SQL Problem..
You'll prob. need to use the (+) to join like this SELECT grp.grpdescrip, grp.grp, grp.createcust, grp.auth1, grp.auth2, usergrp.userid, users.userdescrip FROM grp, usergrp, users WHERE grp.grp = usergrp.grp (+) AND usergrp.userid=users.userid (+) ORDER BY grp.grp -Original Message- From: Nick Oostveen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:47 PM To: Frank S. Kicenko; [EMAIL PROTECTED] Subject: Re: [PHP] 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 -- 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
Re: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php