题解 | 获取所有非manager员工当前的薪水情况
select
dept_emp.dept_no,salaries.emp_no,salaries.salary
from dept_emp,salaries
where dept_emp.emp_no = salaries.emp_no
and dept_emp.emp_no not in(
select
emp_no
from dept_manager
) ;
select
dept_emp.dept_no,salaries.emp_no,salaries.salary
from dept_emp,salaries
where dept_emp.emp_no = salaries.emp_no
and dept_emp.emp_no not in(
select
emp_no
from dept_manager
) ;
相关推荐