大家帮帮忙

use Tempdb
go
--> --> 听雨停了-->生成测试数据
if not object_id(N'A') is null
drop table A
Go
Create table A([编号] int,[姓名] nvarchar(22))
Insert A
select 1,N'张三' union all
select 2,N'李四' union all
select 3,N'王五'
Go
if not object_id(N'B') is null
drop table B
Go
Create table B([人物] nvarchar(22))
Insert B
select N'1' union all
select N'2' union all
select N'刘华'
Go
--测试数据结束
SELECT case isnull(姓名,'') WHEN'' then 人物 else 姓名 end as 人物
FROM B
LEFT JOIN A ON cast(人物 as varchar(20))=cast(编号 as varchar(20))