select A.emp_no,A.salary,A.from_date,A.to_date,	B.dept_no
from salaries A
INNER join dept_manager B
on A.emp_no = B.emp_no
order by A.emp_no ASC