Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the French language
SELECT UserQuestion.Id AS UserQuestionID --UserAnswer.Id as UserAnswerID FROM Posts AS PostQuestion INNER JOIN Posts AS PostAnswer ON PostQuestion.AcceptedAnswerId = PostAnswer.Id INNER JOIN Users AS UserQuestion ON PostQuestion.OwnerUserId = UserQuestion.Id INNER JOIN Users AS UserAnswer ON PostAnswer.OwneruserId = UserAnswer.Id