คำตอบเกี่ยวกับ Y โดยผู้ใช้ที่รู้จัก X และ Y ไม่จำเป็นต้องใช้ตารางทั้งหมด
Answers about Y by Users who know X and Y.It is not neccessary to use all the tables.
 PostTypes:  Id [ number]  Name [ text] 
SELECT DISTINCT tagsY.TagName AS reinvented, 'with' AS presence, tagsX.TagName AS invented, answerer.Id AS answerer_id, answerer.Reputation, answersY.Score AS answer_score, answersY.Id AS answer_id FROM Users AS answerer, Posts AS questionsX, Posts AS answersX, PostTags AS posttagsX, Tags AS tagsX, Posts AS questionsY, Posts AS answersY, PostTags AS posttagsY, Tags AS tagsY WHERE answerer.Reputation BETWEEN 2 AND 100000 AND questionsX.PostTypeId = 1 AND questionsX.Id = posttagsX.PostId AND posttagsX.TagId = tagsX.Id AND tagsX.TagName IN ('pthreads') AND questionsX.Id = answersX.ParentId AND answersX.OwnerUserId = answerer.Id AND questionsY.PostTypeId = 1 AND questionsY.Id = posttagsY.PostId AND posttagsY.TagId = tagsY.Id AND tagsY.TagName IN ('multithreading') AND questionsY.Id = answersY.ParentId AND answersY.OwnerUserId = answerer.Id