SELECT * FROM Posts Inner Join (SELECT AcceptedAnswerId,

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 *

FROM Posts Inner Join 

(SELECT AcceptedAnswerId,
        CreationDate as 'ParentCreationDate'
  FROM Posts
  WHERE Posts.CreationDate < '2018-01-01'
    AND Posts.CreationDate >= '2017-01-01'
    AND AcceptedAnswerID is NOT NULL
    ) as accepted 
    ON Posts.id=accepted.AcceptedAnswerId

WHERE Posts.CreationDate < '2018-01-01'
  AND Posts.CreationDate >= '2017-01-01'

Enter Parameters

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