Join two tables based on same start and end time
Build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in—from in-memory performance and advanced security to in-database analytics.
In this case it would be less than 1 second difference between a.start_time and b.start_time. You could make it wider by using mm, hh instead of ss. Also, if your start times are same, you could just do an inner join with tbl1 and tbl2.
1 Select 2 a.id, 3 a.start_time, a.end_time, 4 a.my_val1, 5 b.my_val2 6 from tbl1 a 7 left join tbl2 b on 8 datediff( ss, b.start_time, a.start_time ) < 1 9 order by a.id;