select 
a.*,
b.dept_no
from salaries a
right join dept_manager b
on a.emp_no=b.emp_no
order by a.emp_no asc