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 vote221 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
19 votes223 views6 answers
What is mySQL
SQL
5 votes217 views1 answer
Migrate sql table another database
SQL
0 vote241 views2 answers
Add new column after in sql
SQL
0 vote214 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote213 views10 answers
John the ripper mysql
SQL
0 vote221 views1 answer
Mysql jdbc timezone
SQL
15 votes235 views3 answers
Postgresql change column type
SQL
0 vote231 views2 answers
Mysql row_number() example
SQL
1 vote222 views1 answer
Temp table vs variable table in sql server
SQL