Extract threads only

[akafi]

Originally Posted by Dave

SELECT thread.title, post.pagetext
FROM thread
INNER JOIN post ON thread.firstpostid = post.postid

Thank you so much Dave it is work well.
I have another question if i want to change dateline from table thread and transfer it to another table in a row date but with format 0000-00-00 00:00:00
How can i do that?

Thanks