self join example

1SELECT
2    e.first_name + ' ' + e.last_name employee,
3    m.first_name + ' ' + m.last_name manager
4FROM
5    sales.staffs e
6INNER JOIN sales.staffs m ON m.staff_id = e.manager_id
7ORDER BY
8    manager;