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

0 vote181 views1 answer
Limit in access query
SQL
0 vote195 views1 answer
Hour differeence in mysql
SQL
4 votes168 views1 answer
Mysql timestamp in laravel migration
SQL
2 votes160 views1 answer
Oracle kill job by sid
SQL
21 votes172 views1 answer
Cheatsheet for sql
SQL
0 vote185 views1 answer
Sql find record cannot cast date
SQL
3 votes178 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote177 views1 answer
On sql table data exists
SQL
0 vote152 views1 answer
SQL division of an integer by another integer get float CAST
SQL
16 votes185 views3 answers
T-SQL Add Column
SQL