解决方案

select salaries.*,dept_no from salaries right join dept_manager on dept_manager.emp_no = salaries.emp_no;