题目 解答 select d.emp_no,s.salary,s.from_date,d.to_date,d.dept_no from dept_manager as d left join salaries as s on d.emp_no=s.emp_no order by s.emp_no;