select manager,supervisor,(n1.firstname+' '+n1.lastname)employee

from employee_new n1

inner join

(

select manager,(n.firstname+' '+n.lastname)supervisor,employee from relation r

inner join employee_new n

on n.id=r.supervisor

where r.manager=1

)r1

on n1.id=r1.employee