SELECT e.EmployeeID, e.FirstName,
       p.Name
 FROM Employees AS e
 INNER JOIN EmployeesProjects AS ep
 ON e.EmployeeID = ep.EmployeeID AND
    e.EmployeeID = 24
 LEFT OUTER JOIN Projects AS p
 ON ep.ProjectID = p.ProjectID AND
    DATEPART(YEAR, p.StartDate) < 2005