I'm working on some performance tests for my ORM. I just noticed this with the 2010; these two queries return results. SELECT distinct UserId FROM Comments WHERE not UserId in (Select ID From Users) order by UserId SELECT distinct OwnerUserId FROM Posts WHERE not OwnerUserId in (Select ID From ...