Q&A for SharePoint enthusiasts
SELECT Users.DisplayName, Posts.Title, Posts.Body FROM Posts LEFT OUTER JOIN Users ON Posts.OwnerUserId = Users.Id