I had something similar. I think it's just not do able as a plain
select.

Joe Celko's SQL for Smarties recommended if you can't do it with plain
select, then create a view with the union, then select from the view.
So:

create view unified_pension (integer) as (select pensionPlan_ID from DB
union selec pensionPlan_ID from DC);

select * from PensionPlans where PensionPland_Id in (select
pensionPlan_ID from unified_pension)

HTH,

George

> -----Original Message-----

> 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)?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003