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

1 vote300 views1 answer
Tsql find foreign key references
SQL
0 vote306 views1 answer
Postgresql on conflict pair
SQL
0 vote294 views1 answer
Mysql select where field like in list
SQL
0 vote236 views1 answer
Oracle last user logon
SQL
1 vote298 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote292 views1 answer
Create new schema mysql
SQL
1 vote277 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote304 views1 answer
Close sql query vb.net
SQL
0 vote308 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
12 votes296 views1 answer
Script to add new column in table sql
SQL