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 vote123 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote115 views1 answer
Sql query for select from specific columns in a table
SQL
1 vote121 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
27 votes126 views6 answers
Set password mysql
SQL
11 votes104 views2 answers
Sql rank
SQL
1 vote112 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote122 views1 answer
Mysql count all table rows
SQL
0 vote106 views1 answer
Oracle date winter time
SQL
1 vote125 views1 answer
How to fetch alternate records from two tables
SQL
0 vote121 views1 answer
Kotlin sqlite delete row
SQL