Q&A for scientific skepticism
SELECT top 10 p.Id as post, c.Id as comm FROM Posts as p LEFT OUTER JOIN Comments as c ON p.Id = c.PostId WHERE c.Id is NULL