34,575
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('Users') IS NOT NULL DROP TABLE Users
IF OBJECT_ID('Relations') IS NOT NULL DROP TABLE Relations
GO
CREATE TABLE Users(
ID INT PRIMARY KEY,
[Name] NVARCHAR(20)
)
CREATE TABLE Relations(
ID1 INT,
ID2 INT,
[cash] INT
)
GO
INSERT INTO Users(ID,Name)VALUES(1,'张三');
INSERT INTO Users(ID,Name)VALUES(2,'李四');
INSERT INTO Users(ID,Name)VALUES(3,'王五');
INSERT INTO Relations VALUES (1,2,100);
INSERT INTO Relations VALUES (1,3,20);
INSERT INTO Relations VALUES (3,2,500);
SELECT u.Name,u2.Name,r.cash
FROM Relations AS r
INNER JOIN Users AS u ON r.ID1=u.ID AND r.id1=1
INNER JOIN Users AS u2 ON r.ID2=u2.ID