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 vote137 views1 answer
Opensuse status MySQL
SQL
11 votes163 views4 answers
Reset identity column values in sql server
SQL
1 vote148 views1 answer
Change table to innodb mysql
SQL
0 vote148 views1 answer
How to find database collation in postgres
SQL
1 vote166 views1 answer
How to show index type in postgresql
SQL
13 votes135 views2 answers
Sql count distinct group by
SQL
0 vote136 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote140 views1 answer
Price-colour
SQL
0 vote145 views1 answer
Drop all procedures sql server
SQL
4 votes174 views6 answers
Select sql
SQL