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 vote141 views2 answers
How to search date in sql query
SQL
1 vote142 views1 answer
Top 10 rows in mysql
SQL
2 votes170 views1 answer
Datefromparts mssql
SQL
2 votes164 views1 answer
Mysql shell insert into
SQL
1 vote141 views1 answer
Pl sql insert into table
SQL
2 votes150 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote123 views1 answer
Foreign key constraint in ms sql
SQL
4 votes135 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote155 views3 answers
Insert query in ci
SQL
2 votes140 views4 answers
Mysql select into new table
SQL