SELECT TOP 1000 [Id],[员工号] ,[员工名],[员工职位]
,(select [员工名] from [Demo].[dbo].[员工表]B where [员工号] =A.[管理者员工号]) as 管理者
,[工资] ,[部门号]
FROM [Demo].[dbo].[员工表] A
SELECT TOP 1000 A.[Id] ,A.[员工号],A.[员工名] ,A.[员工职位]
,B.员工名 as 管理者
,A.[工资] ,A.[部门号]
FROM [Demo].[dbo].[员工表] A
inner join Demo.[dbo].[员工表] B
on A.[管理者员工号]=B.[员工号]