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 vote179 views1 answer
Select all tables linked server sql
SQL
0 vote177 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote161 views1 answer
Lister les index d'une table oracle
SQL
0 vote192 views1 answer
How to move a column to different spot mysql
SQL
0 vote193 views1 answer
Day of the week sqlite
SQL
1 vote167 views1 answer
How to open closed port mysql in ubuntu
SQL
3 votes181 views1 answer
Oracle user quota on tablespace
SQL
0 vote171 views1 answer
Find wordpress version in database
SQL
0 vote171 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote181 views1 answer
Sql select rows with different values in one column
SQL