SELECT e.*, aeo.*
FROM Employee e
INNER JOIN EmployeeHours aeo ON e.EmployeeID = aeo.UserID AND aeo.OccurredDateTime = (SELECT MAX(OccurredDateTime)
FROM ApplicationEventOccurrence aeo
WHERE e.EmployeeID = aeo.EmployeeID
GROUP BY UserID)