select emp_no,
salary,
from_date,
a.to_date,
dept_no
from salaries a
join dept_manager b using(emp_no)