employee manager relationship

SELECT e1.EMPLOYEE_ID, e1.FIRST_NAME, e1.MANAGER_ID, e2.FIRST_NAME  FROM employees e1
JOIN employees e2
WHERE e1.MANAGER_ID = e2.EMPLOYEE_ID