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 vote257 views1 answer
Running mysql from bash sc
SQL
0 vote236 views1 answer
Mariadb hours between two dates
SQL
1 vote232 views1 answer
Mysql pretty date format
SQL
3 votes240 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote232 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote243 views1 answer
Sql server check whether column has same equal values
SQL
-1 vote254 views1 answer
Select first rows postgresql
SQL
1 vote232 views1 answer
User privileges postgresql information_schema
SQL
0 vote289 views1 answer
Mssql find deadlocks
SQL
8 votes264 views2 answers
Oracle undo usage
SQL