unexpected end of SQl command error ORA-921
575330Sep 10 2007 — edited Sep 10 2007I wrote this query as part of a larger query, however I can't seem to figure out why this ection gives me the ORA-921 error after the comparison expression (underlined below).
with
s2n as (
select distinct employeefk, policyref, advicename
from source
where
(payrollfk = (select payrollfk1 from payroll_1) or payrollfk = (select payrollfk2 from payroll_2)) and
displaysequence >= 0
group by employeefk, displaysequence, policyref, classificationtype, advicename, payrollfk)