34,575
社区成员
发帖
与我相关
我的任务
分享
--或者你这样写
SELECT a.*,
(select top 1 b.NickName from AccountsTable b where a.SourceUserID=b.UserID) NickName1,
(select top 1 c.NickName from AccountsTable c where a.TargetUserID=c.UserID) NickName2
FROM RecordTable a
WHERE a.SourceUserID=@dwUserID;
--try
SELECT a.*, b.NickName,c.NickName FROM RecordTable as a,AccountsTable as b,AccountsTable c
WHERE a.SourceUserID=b.UserID and a.TargetUserID=c.UserID
and a.SourceUserID=@dwUserID;
SELECT a.*, b.NickName FROM RecordTable as a,AccountsTable as b
WHERE SourceUserID=@dwUserID and b.UserID=@dwUserID and a.主键=b.主键