Sql period overlap

-- table1          <-----row 1 interval------->
-- table2  <---find this--> <--and this--> <--and this-->

SELECT * 
FROM table1,table2 
WHERE table2.start <= table1.end 
AND (table2.end IS NULL OR table2.end >= table1.start)

Source: stackoverflow.com

Similar codes

2 votes221 views1 answer
Sql as
SQL
2 votes203 views2 answers
Postgresql date at timezone
SQL
0 vote236 views1 answer
Oracle session statistics
SQL
1 vote223 views1 answer
Where database run
SQL
0 vote227 views1 answer
How to get first 10 records of a table in mysql
SQL
5 votes217 views1 answer
Postgresql functions
SQL
2 votes216 views1 answer
Mysql sysdate - 1 day
SQL
1 vote212 views1 answer
Mysql monthname
SQL
2 votes206 views2 answers
Mysql get time from datetime
SQL
0 vote206 views1 answer
Changer un mot de passe mysql
SQL