select
dt.emp_no,
salary,
from_date,
dt.to_date,
dept_no
from dept_manager dt
left join salaries s on dt.emp_no = s.emp_no
order by s.emp_no asc;