FB balks at doing a union in a subquery, e.g.:

select * from Table1
where Table1_ID in (Select Table1_ID from Table2 union Select
Table1_ID from Table3)

Is the only way to achieve that via a stored procedure?

Thanks
Ed Dressel