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

>>>>
>>>>Hi Naomi,
>>>>Your response took 2 minutes. I'd appreciate it if you could cut that down to 1 minute in the future. I am a busy person. (JUST KIDDING, thanks for the prompt response!)
>>>
>>>Smart of you to put kidding in upper case as some with big ego will not understand a joke unless you explicitly and unequivocally indicate that you are not serious. This, of course, does not apply to all present in this thread.
>>
>>I try to be very explicit, especially when dealing with potential language barriers.
>
>I know what you mean. Whenever I talk to people from UK I try to use simpler words <g>.

LOL.