Oracle 8i SQL Problem..
| From: | Frank S. Kicenko | Date: | Sun, 28 Jul 2002 15:26:22 +0000 |
| Subject: | Oracle 8i SQL Problem.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110059@lists.php.net to get a copy of this message | ||
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?