select salaries.*, dept_manager.dept_no from salaries left join dept_manager on salaries.emp_no = dept_manager.emp_no where salaries.to_date = '9999-01-01' and dept_manager.to_date = '9999-01-01' order by salaries.emp_no