使用了右连接。。 select s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no from salaries as s right join dept_manager as d on s.emp_no = d.emp_no group by s.emp_no order by s.emp_no asc;