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

1 vote281 views2 answers
List tables sqlalchemy
SQL
13 votes293 views3 answers
Insert mysql ifile nto database
SQL
2 votes280 views4 answers
List databases in sql server
SQL
2 votes274 views1 answer
Oracle drop table free up space
SQL
0 vote296 views1 answer
Oracle last connexion
SQL
0 vote269 views1 answer
Inner joint
SQL
0 vote278 views1 answer
Update database collation in postgresql
SQL
0 vote262 views1 answer
Remove default constraint sql server
SQL
3 votes288 views2 answers
Install mysql powershell
SQL
33 votes320 views6 answers
Sql delete
SQL