How do I create a list of forum names, topics and associated replies

[MoreThanWYSIWYG]

So, I am presented with the task of exporting all topics and replies for import into Salesforce Chatter Answers. I'm a novice sql user, and can write selects and inserts and such, but nothing too deep.

So what I need to do is create a list of all forums, it's associated sub-forums (if any), it's child topics and all of the topic replies.

Does anyone have a sql statement that can point me in the right direction, or know of another way of getting this data?

Thanks,
Joe

[Zachery]

I don't think there is any simple single query to do that for you.

[Lats]

This should be a good start for you...

SELECT
 forum.forumid AS forumid,
 forum.title AS forumtitle,
 thread.threadid AS threadid,
 thread.title AS threadtitle,
 post.postid AS postid,
 post.pagetext AS posttext,
 post.title AS posttitle
FROM
 forum
LEFT JOIN
 thread ON thread.forumid = forum.forumid
LEFT JOIN
 post ON post.threadid = thread.threadid
ORDER BY
 forum.forumid,
 thread.threadid,
 post.postid

[Zachery]

You're always coming to the rescue with good queries.