left outer self join - easy

show me all employees and their managers

include all employees that do not have a manager

select e1.*,e2.name from employee e1 left outer join employee e2 on e1.managerid=e2.employeeid