我建了3个表,用户表bbsusers,主贴表bbstopic,跟贴表bbsreply.
现在我要根据一篇帖子固定(主贴id)TID=5查询该贴主贴表和跟贴表信息,我在查询主贴作者和跟贴作者时,无法分别哪个是主贴和跟贴作者.SELECT T.TTopic AS 主贴标题, U.UName AS 作者姓名,T.TContents AS 主贴内容,
R.RTopic AS 跟贴标题, R.RContents AS 跟贴内容,R.RTime AS 跟贴时间
FROM BBSUsers AS U
INNER JOIN BBSTopic AS T ON (U.UID=T.TUID)
INNER JOIN BBSReply AS R ON (T.TUID=R.RUID)
WHERE T.TID=5
IN(SELECT U.UName AS 跟贴人姓名 FROM BBSUsers AS U INNER JOIN BBSReply AS R ON (U.UID=R.RUID))
现在我要根据一篇帖子固定(主贴id)TID=5查询该贴主贴表和跟贴表信息,我在查询主贴作者和跟贴作者时,无法分别哪个是主贴和跟贴作者.SELECT T.TTopic AS 主贴标题, U.UName AS 作者姓名,T.TContents AS 主贴内容,
R.RTopic AS 跟贴标题, R.RContents AS 跟贴内容,R.RTime AS 跟贴时间
FROM BBSUsers AS U
INNER JOIN BBSTopic AS T ON (U.UID=T.TUID)
INNER JOIN BBSReply AS R ON (T.TUID=R.RUID)
WHERE T.TID=5
IN(SELECT U.UName AS 跟贴人姓名 FROM BBSUsers AS U INNER JOIN BBSReply AS R ON (U.UID=R.RUID))
解决方案 »
- 写了一个存储过程报错,从数据类型 varchar 转换为 bigint 时出错。
- 怎么让两张表的ID不重复
- 统计IP数和独立用户数,在线等,马上结分
- 请问如何筛选这个表
- 使用Log Explorer?诸位大哥拜托了!!!
- 这个SQL怎么写?
- 查询分析器的问题?---送分!!!
- 我在WIN2000 专业版上装不了SQL SERVER 个人版。
- ado的问题
- 请问primary key的数量多少和数据库的查询,插入,更新的速度是否有很大关系???(xiaoluo)
- SQL SERVER2000中怎样才能设置成只有SQL Server用户才能注册SQL Server?Windows用户不让注册!
- 关于 SQL server 2005 连接本地服务器
SELECT t.TTopic as 主贴标题,u.UName as 主贴作者,t.TContens as 主贴内容,
r.RTopic as 跟帖标题,r.RContents as 跟帖内容,r.RTime as 跟帖时间, v.UName as 跟贴作者
FROM BBSTopic as t
inner join BBSReply as r on r.rtid = t.tid
left join BBSUsers as u on u.uid = t.uid
left join BBSUsers as v on v.uid = r.ruid
WHERE t.tid = 5