[PHP] Oracle 8i SQL Problem..

2002-07-28 Thread Frank S. Kicenko
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

Re: [PHP] Oracle 8i SQL Problem..

2002-07-28 Thread Nick Oostveen
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

RE: [PHP] Oracle 8i SQL Problem..

2002-07-28 Thread Martin Towell
ssage- 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 l

RE: [PHP] Oracle 8i SQL Problem..

2002-07-29 Thread Rudolf Visagie
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'l