select t1.emp_no, t2.emp_no as manager_no, t1.salary as emp_salary, t2.salary as manager_salary from (select d.emp_no,d.dept_no,s.salary from dept_emp d inner JOIN salaries s on s.emp_no = d.emp_no) t1 left JOIN (select dm.dept_no, dm.emp_no,ss.salary from dept_manager dm, salaries ss where ss.emp_...