Q&A about the site for expert genealogists and people interested in genealogy or family history
SELECT P.Id, P.ParentId, P.OwnerUserId, P.AcceptedAnswerId, P.Score, P.Body, P.CreationDate, C.UserId CommentUserId, C.Text CommentText, C.CreationDate CommentCreationDate, (SELECT Name FROM PostTypes AS PT WHERE PT.Id = P.PostTypeId) PostType FROM Posts AS P FULL OUTER JOIN Comments AS C ON C.PostId = P.Id WHERE P.Id = 414905 OR P.ParentId = 414905