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

4 votes243 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote269 views1 answer
Mysql grant grant option
SQL
3 votes289 views1 answer
Laravel paginate raw sql
SQL
2 votes250 views1 answer
Node and mysql like
SQL
7 votes269 views3 answers
Foreign key oracle
SQL
0 vote262 views1 answer
Add colum date in sql
SQL
23 votes278 views6 answers
How to create table in sql
SQL
5 votes254 views2 answers
Oracle tables with column name
SQL
12 votes258 views1 answer
Docker mysql random root password
SQL
0 vote252 views2 answers
Plsql function that return a table
SQL