表1： FC FK
123 456
表2： Key Name
123 昵称
456 用户
现在我想显示 ： 123名称 456 用户
你这问题123是id还是什么啊,列名是什么?看你的感觉直接查select * from Key Name
select * from
(select a.[FC ],b.name from [dbo].[test1] as a,dbo.test2 as b
where a.[FC ] = b.[key]) as ss
,
(select a.[FK],b.name from [dbo].[test1] as a,dbo.test2 as b
where a.[FK] = b.[key]) as cc