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 vote164 views1 answer
How to query all tables mysql at the same time
SQL
0 vote166 views1 answer
Intellij idea add mysql connector
SQL
0 vote159 views1 answer
Oracle create job if not exists
SQL
14 votes192 views1 answer
Excel is not a database
SQL
0 vote153 views1 answer
Sql show all users
SQL
1 vote150 views1 answer
What is int in mysql
SQL
5 votes173 views2 answers
Create table mysql example auto_increment
SQL
1 vote150 views1 answer
Media sql
SQL
4 votes148 views3 answers
Sql drop database if exists
SQL
0 vote171 views1 answer
How to find total working hour in sql
SQL