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 vote309 views1 answer
Case when with count and combining similar values in sql
SQL
7 votes309 views2 answers
Sql empty table
SQL
0 vote309 views1 answer
Mysql join only one column
SQL
4 votes349 views1 answer
Postgres delete last row
SQL
3 votes304 views3 answers
Mysql order by list
SQL
0 vote358 views1 answer
Select * from mysql.proc
SQL
17 votes305 views3 answers
Cast in sql server
SQL
1 vote340 views1 answer
T-sql disable system versioning
SQL
0 vote291 views1 answer
Describe in sqlite3
SQL
2 votes296 views1 answer
Alter table add multiple columns postgresql
SQL