SQL查询优化：使用IN子句查询员工信息

SELECT emp.empid, emp.'name' FROM emp JOIN holiday ON emp.empid = holiday.empid WHERE emp.empid IN (SELECT empid FROM holiday)

原文地址: https://www.cveoy.top/t/topic/ouJm 著作权归作者所有。请勿转载和采集!