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

2 votes146 views2 answers
Oracle multiple insert
SQL
0 vote141 views3 answers
Get free card roblox
SQL
0 vote165 views1 answer
Date 3 months from today sql
SQL
0 vote166 views1 answer
Merge clause with inner join
SQL
22 votes144 views4 answers
Show list of users in mysql
SQL
0 vote161 views1 answer
Connect postgresql using a connection string
SQL
0 vote167 views1 answer
Oracle decode
SQL
1 vote140 views1 answer
Mysql select month and year
SQL
-1 vote145 views1 answer
How to open blade file from blade in laravel
SQL
0 vote147 views1 answer
Version and edition of SQL Server Database Engine
SQL