— 不推荐
SELECT * FROM Employee WHERE id IN (SELECT employee_id FROM Performance WHERE score > 80);
— 推荐
SELECT e.* FROM Employee e JOIN Performance p ON e.id = p.employee_id WHERE p.score > 80;
利唐i人事HR社区，发布者：HR_learner，转转请注明出处：https://www.ihr360.com/hrnews/20241245835.html
