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
Postgresql like
SQL
0 vote273 views1 answer
Truncate table sql server foreign key
SQL
3 votes281 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
10 votes283 views4 answers
Inner join in update query mysql
SQL
37 votes367 views6 answers
Mysql update
SQL
4 votes285 views2 answers
Postgresql reset sequence
SQL
0 vote303 views3 answers
Java hide mysql login credentials
SQL
0 vote266 views1 answer
Sql developer format sql
SQL
0 vote289 views1 answer
Mysql select statement after index
SQL
1 vote290 views1 answer
Sql server datetime vs datetime2
SQL