SELECT empempid name FROM emp JOIN holiday on empempid=holidayempid WHERE empid = SELECT empid FROM holiday 改正
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/ghMu 著作权归作者所有。请勿转载和采集!