/* select t1.emp_no, t2.salary,t2.from_date,t2.to_date,t1.dept_no
from salaries as t2 left join dept_manager as t1 on t1.emp_no = t2.emp_no
where t2.to_date='9999-01-01' and t1.to_date='9999-01-01'
order by t1.emp_no asc
*/

select * from (select dept_manager.emp_no, salaries.salary,salaries.from_date,salaries.to_date,dept_manager.dept_no
from salaries as salaries left join dept_manager as dept_manager on dept_manager.emp_no = salaries.emp_no
where salaries.to_date='9999-01-01' and dept_manager.to_date='9999-01-01')t3
order by emp_no asc