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 vote201 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote221 views1 answer
How to fetch alternate records from two tables
SQL
0 vote222 views1 answer
Find how many tables in database sql query
SQL
0 vote217 views2 answers
Identity syntax in sql
SQL
1 vote203 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote191 views1 answer
Oracle string substitution
SQL
32 votes217 views6 answers
How to change column name in sql
SQL
0 vote196 views1 answer
How to define a save method in ruby for sql databases
SQL
13 votes204 views5 answers
Select last row mysql
SQL
2 votes210 views4 answers
Sql query interview questions
SQL