0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT p.Id, isnull(p2.Title, p.Title) AS [Title], pt.Name, p2.AcceptedAnswerId
FROM Posts p
JOIN PostTypes pt
ON p.PostTypeId = pt.Id
LEFT JOIN Posts p2
ON p2.Id = p.ParentId
WHERE p.OwnerUserId = 7816

view current version

edited jan 23 12

created jan 23 12 Ian Pugsley