Error with <> ALL if Subquery not starting with Select

Error - expecting `SELECT'
SELECT NVL(MIN(a.LOAD_ID),-1) FROM PC_JOB_LIST a
WHERE (a.sync_status is null or a.sync_status <> ALL (2,5)) and (a.job_type_code=15)

SELECT NVL(MIN(a.LOAD_ID),-1) FROM PC_JOB_LIST a
WHERE (a.sync_status is null or a.sync_status <> ALL (SELECT 2 union all SELECT 5)) and (a.job_type_code=15)

No comments:

Post a Comment