How to query start and end times in two separate tables to determine if there is any overlap.
Posted on 2004-10-13
I have two separate tables. Each table has a start_time and and end_time field. They are all in DateTime format. I want to find a way to determine whether these two time periods have any overlap.
tbl1.start_time = 11:30 a.m.
tbl1.end_tme1 = 12:30 p.m.
tbl2.start_time2 = 11:00 a.m.
tbl2.end_time2 = 1:00 p.m.
In this example the result would be true.
Thanks in advance for your help.