This question already has an answer here:

I was trying to link the Stack Exchange data together from the archive.org data dump as my college database subject project, but I can't understand how to link the Post and its answer. I tried to link using postlinks relation, but it didn't work that way...

Any kind of help is appreciated.

marked as duplicate by Glorfindel, Shadow The Dragon Wizard support Feb 21 at 15:08

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


On the posts data set, there is a ParentId field. For answers, this is the Id of the "parent" question. Questions are PostTypeId = 1 and answers are PostTypeId = 2.

Not the answer you're looking for? Browse other questions tagged .