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
(
)
WHERE MyField = @MyFilter