SELECT Posts.Id, Posts.CreationDate, Comments.CreationDate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications Meta

Q&A about the site for power users of web applications

-- Most popular StackOverflow tags in May 2010

SELECT Posts.Id, Posts.CreationDate, Comments.CreationDate

FROM Posts RIGHT JOIN Comments ON Posts.AcceptedAnswerId = Comments.Id

WHERE Comments.Id IN

(SELECT Posts.AcceptedAnswerId
FROM Posts
WHERE Posts.AcceptedAnswerId IS NOT NULL)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results