select t1.dept_no, t2.emp_no, t1.salary from (select a.dept_no, max(b.salary) salary from dept_emp a join salaries b on a.emp_no = b.emp_no and a.to_date = '9999-01-01' and b.to_date = '9999-01-01' group by a.dept_no)as t1 join (select a.dept_no, a.emp_no, b.salary from dept_emp a join salaries b on...