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 vote352 views1 answer
Oracle gather table statistics
SQL
0 vote351 views1 answer
Mariadb mysql root access denied
SQL
3 votes507 views9 answers
Linq to sql converter online
SQL
1 vote373 views1 answer
Postgresql append array
SQL
0 vote346 views2 answers
Database owner can't create new tables postgres
SQL
1 vote376 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote390 views1 answer
Date datatype in livesql
SQL
1 vote366 views1 answer
Tsql create unique index composite
SQL
5 votes370 views1 answer
Oracle sysdate - 1 month
SQL
0 vote390 views2 answers
Default constraint in ms sql
SQL