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

6 votes110 views3 answers
Update with inner join postgres
SQL
5 votes122 views2 answers
Mysql drop table cascade
SQL
3 votes237 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote123 views3 answers
Drop multiple columns in sql
SQL
0 vote108 views1 answer
Lost connection to mysql
SQL
0 vote126 views1 answer
Alter database name script
SQL
-1 vote104 views1 answer
Plsql while
SQL
1 vote101 views1 answer
Tsql random number
SQL
3 votes110 views2 answers
Sql paging query
SQL
0 vote106 views3 answers
Sql count condition
SQL