>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
>

Try using derived table (or CTE), e.g.

;with cte as (Here goes UNIONoned query)

select * from cte where ...