select
    a.emp_no,
    a.salary,
    a.from_date,
    a.to_date,
    b.dept_no
from
    salaries a 

join 
dept_manager b 

using(emp_no)
order by a.emp_no asc