帖子列表可以用这个:select bbs.title as '标题',`user1`.user_name as '作者',`user2`.user_name as '回复人' from `user` as user1, `user` as user2, `bbs` where bbs.user_id = `user1`.user_id and bbs.reply_user_id = `user2`.user_id
SELECT * FROM bbs LEFT JOIN user ON bbs.user_id = user.user_id LEFT JOIN bbs_detail ON bbs.bbs_id = bbs_detail.bbs_id;
select bbs.title user.user_name user.user_name from user bbs where bbs.user_id=user.user_id and user.user_id=bbs.reply_user_id
将你的表结构 Create Table , 表数据 Insert Into , 语句, 以及需要的结果帖出来
你把正确的写出来呀,成功就给分!
from `user` as user1, `user` as user2, `bbs`
where bbs.user_id = `user1`.user_id and bbs.reply_user_id = `user2`.user_id
LEFT JOIN user ON bbs.user_id = user.user_id
LEFT JOIN bbs_detail ON bbs.bbs_id = bbs_detail.bbs_id;
from user bbs
where bbs.user_id=user.user_id and user.user_id=bbs.reply_user_id
表数据 Insert Into ,
语句,
以及需要的结果帖出来
10天前还不知道Join是什么,呵呵