This query works fine on by DB:

select pensionPlan_ID from DB union
select pensionPlan_ID from DC

but this one does not:

select * from PensionPlans where PensionPland_Id in
(select pensionPlan_ID from DB union
select pensionPlan_ID from DC)

It does not like the word 'union'--is there a way to achive the same
results (i.e. all items in PensionPlans that do not have an ID in the
DB or DC tables)?

Thanks
Ed Dressel