I'm having a Monday morning brain fart. In my query, I am performing a union against several tables to return one result set. I'd like to perform a where clause against that entire result set, but I'm not figuring out how to do it.

Something like:

SELECT * FROM
(
   --Union logic here
)
WHERE MyField = @MyFilter