Or something like:

select A.*
from PensionPlans A LEFT JOIN DB B
ON A.PensionPland_Id = B.pensionPlan_ID
LEFT JOIN DC C
ON A.PensionPland_Id = C.pensionPlan_ID
where B.PensionPland_Id IS NULL AND C.PensionPland_Id IS NULL

Juan Jose.

--- In firebird-support@yahoogroups.com, "Ed Dressel" <Dressel@A...>
wrote:

> 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