0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

-- Accepted answers

SELECT PQ.id
-- , PQ.AcceptedAnswerId
, PQ.Title AS QuestionId
, PA.id
-- , PA.PostTypeId
, PA.Score
-- , IsAccepted = CASE PA.id WHEN PQ.AcceptedAnswerId THEN 'yes' ELSE 'no' END
, (SELECT PL.Score FROM Posts PL WHERE PL.Id=PQ.AcceptedAnswerId) AS [Accepted Score]
FROM posts PQ
INNER JOIN posts PA ON PA.ParentId=PQ.id

fork query

created feb 22 11 david.friedland