DELETE
FROM job_history j
WHERE (employee_id, job_id) = ALL
(SELECT employee_id, job_id
FROM employees e
WHERE j.employee_id = e.employee_id and j.job_id = e.job_id );
该SQL不能从 job_history 删除 和employees的 employee_id、job_id 相同的记录,有点疑惑,谁解释下,很是感谢
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21126685/viewspace-670313/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21126685/viewspace-670313/