Are my eyes failing on me ?
The error is vague and I can't track down whats wrong because it keeps pointing to the word with.
With myTEST(Name_last)
as (select Distinct Name_last
from Medicaid_Eligibility_Patients_Batch
where source = 'DIALYSIS' and
(
(Name_last = 'TESTER' and Name_first = 'PAUL') or
(Name_last = 'TESTER' and Name_first = 'JOHN')
)
)
insert into Medicaid_Eligibility_Patients_Exclusions
Select Name_last
from myTEST
...
Go to the complete details ...