That exists did the trick (I was halfway their before your response).

thanks for all the help guys.

Alright, so I will put it in the where clause.  Now, what sql should I use in the where clause so it basically returns a yes if one or more...

I was trying to spare anyone the agony of looking at this nasty long query.

To simplify: I was just trying to determine the best way to add to the screening to not bring...

Thanks John,

I don't think I was very clear, what I having trouble determining, is where in the existing query can I put the logic(in the where clause or create a new having...