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 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 .