select 
   s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no
from dept_manager d
left join salaries s
on d.emp_no=s.emp_no