--这样试一下! Create Table Users(Userid Int,UserName Varchar(10)) Insert Users Select 2100,'小王' Union All Select 2101 ,'小李' ---------- Create Table t2(Userid Int,Inid Int) Insert t2 Select 2100,2101 ----------- SELECT dbo.Users.UserName, Users_1.UserName AS User1 FROM dbo.Users INNER JOIN dbo.t2 ON dbo.Users.Userid = dbo.t2.Inid INNER JOIN dbo.Users Users_1 ON dbo.t2.Userid = Users_1.Userid
这样试一下: declare @t1 Table(Userid Int,UserName Varchar(10)) Insert @t1 Select 2100,'小王' Union All Select 2101 ,'小李' declare @t2 Table(Userid Int,Inid Int) Insert @t2 Select 2100,2101 SELECT a.username as UserID,b.username as Inid FROM @t2 x LEFT JOIN @t1 a ON x.userid = a.userid LEFT JOIN @t1 b ON x.inid = b.userid
Create Table Users(Userid Int,UserName Varchar(10))
Insert Users Select 2100,'小王'
Union All Select 2101 ,'小李'
----------
Create Table t2(Userid Int,Inid Int)
Insert t2 Select 2100,2101
-----------
SELECT dbo.Users.UserName, Users_1.UserName AS User1
FROM dbo.Users INNER JOIN
dbo.t2 ON dbo.Users.Userid = dbo.t2.Inid INNER JOIN
dbo.Users Users_1 ON dbo.t2.Userid = Users_1.Userid
declare @t1 Table(Userid Int,UserName Varchar(10))
Insert @t1
Select 2100,'小王' Union All
Select 2101 ,'小李'
declare @t2 Table(Userid Int,Inid Int)
Insert @t2 Select 2100,2101
SELECT a.username as UserID,b.username as Inid FROM @t2 x
LEFT JOIN @t1 a ON x.userid = a.userid
LEFT JOIN @t1 b ON x.inid = b.userid