Absent Date

0
261

SELECT e.Name
FROM Employee e
WHERE e.ManagerId = 15
AND e.Name NOT IN
(
SELECT DISTINCT e.Name
FROM Log l
INNER JOIN Employee e ON l.EmployeeId = e.EmployeeId
WHERE e.ManagerId = 15
)