看到部分思路不完全，请勿忽略排序！！order by s.emp_no

SELECT s.*, d.dept_no FROM salaries AS s ,  dept_manager AS d
WHERE s.emp_no=d.emp_no order by s.emp_no;