SELECT s.emp_no,	salary,	from_date,	s.to_date ,dm.dept_no
FROM salaries AS s INNER JOIN dept_manager dm ON s.emp_no = dm.emp_no
WHERE s.emp_no IN (SELECT emp_no
                FROM dept_manager)    
ORDER BY s.emp_no