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 vote191 views1 answer
Date on SQL
SQL
0 vote211 views2 answers
PostgreSQL having
SQL
0 vote187 views1 answer
Mysql trim characters
SQL
10 votes172 views2 answers
Linux command line import mysql database
SQL
15 votes186 views5 answers
If null mysql
SQL
1 vote179 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote150 views1 answer
Database run
SQL
0 vote267 views1 answer
Microsoft sql server python connection
SQL
1 vote228 views1 answer
Psql client write to bash variable
SQL
9 votes203 views6 answers
Check constraint in sql
SQL