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

Reply via email to