题解 | 获取所有非manager的员工emp_no
select t.emp_no_1 from ( select t1.emp_no as emp_no_1 , t2.emp_no as emp_no_2 from employees as t1 left join dept_manager as t2 on t1.emp_no = t2.emp_no) as t where t.emp_no_2 is null;
select t.emp_no_1 from ( select t1.emp_no as emp_no_1 , t2.emp_no as emp_no_2 from employees as t1 left join dept_manager as t2 on t1.emp_no = t2.emp_no) as t where t.emp_no_2 is null;
相关推荐