考查两表关联 

select s.* ,m.dept_no FROM dept_manager m,salaries s
where s.emp_no=m.emp_no  order by s.emp_no