Hi,
i have an query that use UNION. How could I query the certain records from the exisitng recordset?

select * from table1 where condition A = true
UNION
select * from table2 where condition B = true
UNION
select * from table3 where condition C = true

(REFERENCE BY MYRS1)

I need to get certain records only from MYRS1.

Any ideas?

Thank you