#将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
#将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