Q&A for SharePoint enthusiasts
SELECT TOP 10 Posts.Id, Posts.Title FROM Posts LEFT JOIN Comments ON Posts.Id = Comments.PostId WHERE Comments.Id IS NULL