EID vs ManagerName

I have a table  empsalary with columns as eid,ename,emanager I need result table as

Create table empSalary(eid int,ename varchar(20),esal money,eManager int null)

insert into empsalary values(1,'rghu',20000,null)

insert into empsalary values(2,'en',15000,1)

insert into empsalary values(3,'ven',10000,2)

insert into empsalary values(4,’murthys’,15000,1)

insert into empsalary values(5,'karim',10000,2)

insert into empsalary values(6,'sir',18000,2)

insert into empsalary values(7,'siri',20000,null)

select *from empsalary order by esal desc

EId,Ename.Manager

select e.eid,e.ename,isnull(s.ename,'No Manager') as manager from empsalary e

left outer join (select * from empsalary )as  s on s.eid=e.emanager