[技術]SQL IN EXISTS AND NOT EXISTS用法
[mw_shl_code=sql,true]SELECT Emp_ID,Emp_Name,Ext,Dept_ID
FROM Employees
WHERE Dept_id IN
(SELECT Dept_ID from Departments
WHERE Mgr_id IN('890032','880017')
)
ORDER BY Dept_id,Emp_Name
SELECT Emp_ID,Emp_Name,Ext,Dept_ID
FROM Employees E
WHERE EXISTS
(SELECT Dept_ ...