题解 | #查找当前薪水详情以及部门编号dept_no#

select salaries.emp_no , salaries.salary, salaries.from_date , salaries.to_date , dept_manager.dept_no from dept_manager left join
salaries on dept_manager.emp_no = salaries.emp_no;