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

3 votes361 views3 answers
Stop mysql ubuntu
SQL
1 vote325 views1 answer
Check message id sql server
SQL
25 votes360 views3 answers
How to use a database to see tables mysql
SQL
3 votes328 views2 answers
Sqlite show table definition
SQL
-2 votes328 views3 answers
Oracle tablespace usage
SQL
0 vote361 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote346 views1 answer
Alter column to not null with default value sql server
SQL
1 vote336 views1 answer
Mysql month name extract
SQL
0 vote441 views1 answer
How to rename a database in tsql
SQL
11 votes324 views1 answer
Ddl materialized view
SQL