1、查询部门经历的id
select emp_no from dept_manager2、将员工表和薪水表内连接,where筛选不是部门经理的薪水
select a.dept_no,a.emp_no,b.salary from dept_emp a join salaries b on a.emp_no=b.emp_no where a.emp_no not in (select emp_no from dept_manager);
select emp_no from dept_manager2、将员工表和薪水表内连接,where筛选不是部门经理的薪水
select a.dept_no,a.emp_no,b.salary from dept_emp a join salaries b on a.emp_no=b.emp_no where a.emp_no not in (select emp_no from dept_manager);