MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COALESCE(c.DETDESC,'') != ''
ORDER BY c.NAME, c.ID' at line 4
SELECT c.ID, c.DETDESC, c.NAME, c.NAME1
FROM classes c
WHERE 0=0 AND COALESCE(c.PARENTOBJID,0)=
AND COALESCE(c.DETDESC,'') != ''
ORDER BY c.NAME, c.ID
1: SELECT c.ID, c.DETDESC, c.NAME, c.NAME1
2: FROM classes c
3: WHERE 0=0 AND COALESCE(c.PARENTOBJID,0)=
4: AND COALESCE(c.DETDESC,'') != ''
5: ORDER BY c.NAME, c.ID
