serg-52 (10/30/2014)
Yep, overlapping condition ... Generaly, overlapping meanst1.starttime < t2.finishtime AND t2.starttime < t1.finishtime
i.e those intervals have at least one common point. And this condition is symmetric.
Sorry, haven't noticed you are using different condition which is not symmetric.
If the above meaning is correct for your purpose, try symmetric one.
Thanks again for the reply.
I as essentially looking for any times in table1 (t1) that intersect any times in the same table (t2) where the jobnum and empid match.
The times are from a time booking system - an employee books his time to jobs throughout the day and this is to check to see if he/she has accidentally put times in that overlap each other (i.e. no employee can work on more than 1 job at a time).
I'm not quite sure what you mean as symmetric conditions or how to try them?