DELETE
t1
FROM
t_employee t1
WHERE
t1.n_id NOT IN (
SELECT DISTINCT
t.n_employee_id
FROM
t_dept_employee t
)
版权声明：本文为u012129031原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。