34,591
社区成员
发帖
与我相关
我的任务
分享
SELECT t2.name
, t3.name
FROM 表1 AS t1
INNER JOIN 表2 AS t2 ON t2.id=t1.Col1
INNER JOIN 表2 AS t3 ON t3.id=t1.Col2
USE tempdb
GO
IF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1
IF OBJECT_ID('t2') IS NOT NULL DROP TABLE t2
GO
CREATE TABLE t1(
id1 INT,
id2 INT
)
CREATE TABLE t2(
id INT,
remark NVARCHAR(10)
)
INSERT INTO t1(id1,id2) VALUES(1,2)
INSERT INTO t2(id,remark) VALUES(1,'A')
INSERT INTO t2(id,remark) VALUES(2,'B')
GO
----------- 以上是测试表及测试数据 -----------
SELECT
(SELECT remark FROM t2 WHERE t1.id1=t2.id) AS r1,
(SELECT remark FROM t2 WHERE t1.id2=t2.id) AS r2
FROM t1
/*
r1 r2
A B
*/