#将salaries和dept_manager进行联结
select a.*,b.dept_no
from salaries as a
join dept_manager as b
on a.emp_no=b.emp_no
group by a.emp_no