I changed them all to left joins and still nothing.

Can't see why this wouldn't be working, it follows the same logic of what you just posted.

Thanks for this. It still only returned the one row. I will work on putting the data/table structures together and post it up here.

I am working on getting those tables together if this one doesn't work, that will take me some time. Thanks for bearing with me.

That query looks like what I need,...

This is an example of how the virtual table was working:

http://sqlfiddle.com/#!3/f2bb4/1

The whole larger query is checking an anti-virus database for hosts within 5 different groups that have out of date...

Thanks, this query runs but its not giving me the result I was looking for.

For example, this query returned one row with MMT. However, I would like to receive the...

The second query prints a row with '1's if no IM.NAME values exists that are like a value in the virtual table tagTypes

Ok, no problem. Thanks

Thanks for the response.

I tried the new query and received this error "Incorrect syntax near ')'. Incorrect syntax near 'tagTypes'. Incorrect syntax near the keyword 'AND'."

I know these are small...