0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

SELECT 
    P.Id AS QuestionId,
    P.Title AS QuestionTitle,
    P.Body AS QuestionBody,
    A.Body AS AnswerBody
FROM 
    Posts P
JOIN 
    Posts A ON P.Id = A.ParentId
WHERE 
    P.PostTypeId = 1  -- Only questions
    AND A.PostTypeId = 2  -- Only answers
    AND P.ClosedDate IS NULL  -- Exclude closed questions
ORDER BY 
    P.CreationDate DESC

fork query

created sep 7 anonymous