SELECT
    dp.emp_no as emp_no,
    sa.salary as salary,
    sa.from_date as from_date,
    sa.to_date as to_date,
    dp.dept_no as dept_no
FROM
    dept_manager dp 
    LEFT JOIN salaries sa
    ON sa.emp_no = dp.emp_no
ORDER BY
    dp.emp_no ASC;