求一简单SQL

[atmo]

表table1
AID BID
2 3

表table2
id name
2 张三
3 李四

一条语句求出

table1内容 结果

张三 李四

[二月十六]

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([AID] int,[BID] int)
Insert #T
select 2,3
GO
if not object_id(N'Tempdb..#T1') is null
	drop table #T1
Go
Create table #T1([id] int,[name] nvarchar(22))
Insert #T1
select 2,N'张三' union all
select 3,N'李四'
Go
--测试数据结束
SELECT  a.name ,
        b.name
FROM    #T
        JOIN #T1 a ON a.id = #T.AID
        JOIN #T1 b ON b.id = #T.BID;

[atmo]

有一点没说明白 表table1 AID BID other1 other2 2 3 value1 value2 表table2 id name 2 张三 3 李四 结果 张三 李四 value1 value2

[二月十六]

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([AID] int,[BID] INT,other1 NVARCHAR(100),other2 NVARCHAR(100))
Insert #T
select 2,3,'value1','value2'
GO
if not object_id(N'Tempdb..#T1') is null
	drop table #T1
Go
Create table #T1([id] int,[name] nvarchar(22))
Insert #T1
select 2,N'张三' union all
select 3,N'李四'
Go
--测试数据结束
SELECT  (SELECT TOP 1 name FROM #T1 WHERE id=AID) ,
        (SELECT TOP 1 name FROM #T1 WHERE id=BID),
		other1,other2
FROM    #T