Finding time overlaps

[JKlein]

I have a table that holds meeting data: EmployeeID, MeetingDate, StartTime,
and EndTime. I need a query that shows all the records that have overlaping
times.
Any Ideas?

 

[Marshall Barton]

I have a table that holds meeting data: EmployeeID, MeetingDate, StartTime,
and EndTime. I need a query that shows all the records that have overlaping
times.

SELECT T.EmployeeID, T.MeetingDate, T.StartTime, T.EndTime
FROM table As T, table As X
WHERE T.EmployeeID = X.EmployeeID
AND T.MeetingDate = X.MeetingDate
AND T.StartTime < X.EndTime
AND T.EndTime > X.StartTime