发贴信息表 createpost
(messageID usrename title createdate)回复信息表 reply
(回复帖子ID reID 帖子ID messageID )
查询用户回帖的标题和时间写下完整SQL
(messageID usrename title createdate)回复信息表 reply
(回复帖子ID reID 帖子ID messageID )
查询用户回帖的标题和时间写下完整SQL
select t1.title,t2.createdate from createpost t1,createpost t2,reply
where t1.messageid=reply.贴子id and t2.messageid=reply.messageid