主题表T_announces:id, topic,authorID, lastReplyUserID,boardID
用户表T_users:id,name如何编写sql查询
select id, topic,authorID, lastReplyUserID,boardID
from T_announces
where boardID=@id使得用T_users表的name替代结果里的authorID和lastReplyUserID
用户表T_users:id,name如何编写sql查询
select id, topic,authorID, lastReplyUserID,boardID
from T_announces
where boardID=@id使得用T_users表的name替代结果里的authorID和lastReplyUserID
c.name as lastReplyUserName,boardID from
T_announces a
left join T_users b
on a.authorID=b.id
left join T_users c
on a.lastReplyUserID=c.id
select A.id, A.topic,B.NAME AS authorname, C.NAME AS lastreplyusername,A.boardID
from T_announces A
LEFT JOIN T_users B ON A.authorid = B.id
LEFT JOIN T_users C ON A.lastreplyuserid = C.id
where A.boardID=@id