0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

-- 특정 질문에 대한 모든 답변 조회
SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.AnswerCount,
    q.CommentCount,
    q.CreationDate AS QuestionCreationDate,
    q.FavoriteCount,
    q.LastActivityDate AS QuestionLastActivityDate,
    q.LastEditDate AS QuestionLastEditDate,
    q.LastEditorDisplayName AS QuestionLastEditorDisplayName,
    q.LastEditorUserId AS QuestionLastEditorUserId,
    q.OwnerDisplayName AS QuestionOwnerDisplayName,
    q.OwnerUserId AS QuestionOwnerUserId,
    q.Score AS QuestionScore,
    q.Tags AS QuestionTags,
    q.ViewCount AS QuestionViewCount,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    a.Body AS AnswerBody
FROM
    Posts q
INNER JOIN
    Posts a ON q.Id = a.ParentId  -- 질문(q)의 Id와 답변(a)의 ParentId가 일치하는 경우 조인
WHERE
    q.PostTypeId = 1  -- 질문
    AND a.PostTypeId = 2  -- 답변
    AND q.Id IN (2517, 4944)  -- 원하는 질문 ID들을 여기에 넣습니다.
ORDER BY
    q.CreationDate, a.CreationDate;

fork query

edited oct 22

created oct 22 anonymous