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 vote267 views1 answer
Sql server list locks
SQL
3 votes258 views3 answers
Create a view postgres
SQL
0 vote245 views2 answers
How to find max and min salary in sql
SQL
1 vote205 views1 answer
Flask-sqlalchemy filter_by contains
SQL
7 votes253 views1 answer
Safe update mysql
SQL
-1 vote257 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
3 votes249 views3 answers
Sql current year
SQL
1 vote257 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote277 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote256 views1 answer
Oracle duration between timestamps
SQL