Hi Steve,

I haven't tested it on your data, but I guess you need to add an extra employeeID join condition to all your joins:

SELECT

s1.EmployeeId,

s1.LogInTime,

MIN(t1.LogOutTime) AS LogOutTime

FROM Overlapping s1

INNER JOIN Overlapping...