34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT u.username[发贴人姓名]
FROM BBSTOPIC T
LEFT JOIN BBSUSERS U
ON
T.TUID = U.UID
WHERE
TUID = 1
select
a.UserName,c.RTopic
from
BBSUsers a join BBSTopic b on a.uid=b.tuid join BBSReply c
on
b.tid=c.rtid
where a.tid=1
select
a.UserName,c.RTopic
from
BBSUsers a join BBSTopic b on a.uid=b.tuid join BBSReply c
on
b.tid=c.rtid
and a.tid=1
select
a.UserName,c.RTopic
from
BBSUsers a,BBSTopic b,BBSReply c
where
a.uid=b.tuid
and
b.tid=c.rtid
and a.tid=1