SELECT p1.Id, p1.Title, acc.Score as AcceptedScore FROM P...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p1.Id, p1.Title, acc.Score as AcceptedScore FROM POSTS p1
  -- INNER JOIN POSTS p2 on p2.ParentId = p1.Id and p2.PostTypeId = 2
  INNER JOIN POSTS acc on acc.Id = p1.AcceptedAnswerId
WHERE p1.PostTypeId = 1;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results