OK...The light bulb has turned on.  Thanks for your help and have a great week! 

Thanks for all your input on this. So, what you are saying is that any column from table1 placed in the sub select will return the same results since...

I see what you are saying, but the query does returns 7 rows. That is what makes it so strange. It's like sql server is not even evaulating...