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

7 votes127 views2 answers
Create index mysql
SQL
1 vote123 views1 answer
How to change owner in postgres
SQL
0 vote118 views1 answer
Sql menampilkan data tabel
SQL
1 vote121 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote145 views1 answer
Mysql export data with a where clause
SQL
7 votes132 views1 answer
Query postgres delete duplicates
SQL
0 vote84 views1 answer
Get last run query sql server
SQL
15 votes133 views4 answers
Pl sql
SQL
0 vote134 views1 answer
Php get closest location by latitude longitude
SQL
5 votes128 views2 answers
Oracle tables with column name
SQL