SELECT e.EMPLOYEE_ID,e.SALARY,e.MANAGER_ID,mng.FIRST_NAME,mng.SALARY
FROM employees AS e
JOIN
employees AS mng
ON e.MANAGER_ID = mng.EMPLOYEE_ID;
SELECT e.EMPLOYEE_ID,e.SALARY,e.MANAGER_ID,mng.FIRST_NAME,mng.SALARY
FROM employees AS e
JOIN
employees AS mng
ON e.MANAGER_ID = mng.EMPLOYEE_ID;
Add your comment