Q&A for SharePoint enthusiasts
SELECT q.Id AS QuestionId, q.Title AS QuestionTitle, q.Body AS QuestionBody, q.AcceptedAnswerId, q.AnswerCount, q.CommentCount, q.CommunityOwnedDate, 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.AcceptedAnswerId = a.Id WHERE q.PostTypeId = 1 AND a.PostTypeId = 2 AND q.Id IN (2517, 4944) -- 여기에서 지정한 질문 ID들만 선택 ORDER BY q.CreationDate;