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 vote214 views1 answer
Modifier une valeur sql
SQL
0 vote239 views1 answer
How to insert same table data using mysql query
SQL
0 vote201 views1 answer
T-sql email validation
SQL
15 votes407 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote259 views1 answer
Sql from null to not null
SQL
0 vote192 views4 answers
Sql limit 1 offset 1
SQL
10 votes256 views4 answers
Else if mysql
SQL
10 votes243 views4 answers
Join multiple tables in sql
SQL
8 votes240 views2 answers
Sqlsrv default port
SQL
0 vote187 views1 answer
Ms sql database data size
SQL