0

Please login or register to vote for this query.

(click on this box to dismiss)

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 = 420084 OR P.ParentId = 420084

fork query

edited nov 29 23

created nov 16 23 anonymous