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 vote163 views1 answer
Show table status command in mysql
SQL
0 vote139 views2 answers
Delete the last item in a table sql
SQL
1 vote174 views1 answer
Create sqlite database in laravel
SQL
1 vote236 views2 answers
Begin transaction sql
SQL
4 votes179 views1 answer
Describe table mysql
SQL
3 votes166 views3 answers
Remove all spaces from string sql
SQL
0 vote198 views1 answer
Distance calculator from lat long sql query
SQL
13 votes169 views5 answers
Select last row mysql
SQL
0 vote171 views1 answer
Compare two tables to find unmatched records
SQL
1 vote156 views1 answer
Show indices in mysql table
SQL