SELECT a.dept_no, a.emp_no, MAX(sal.salary)
FROM dept_emp a left join salaries sal
ON a.emp_no = sal.emp_no
WHERE a.to_date = '9999-01-01' and sal.to_date = '9999-01-01'
GROUP BY a.dept_no