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 views1 answer
Sql into vs insert into
SQL
0 vote146 views1 answer
Alter table add check constraint oracle
SQL
16 votes145 views3 answers
T-SQL Add Column
SQL
15 votes145 views3 answers
Find duplicate keys in mysql
SQL
8 votes145 views2 answers
Safe update mode in mysql
SQL
0 vote141 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote144 views1 answer
Implicit inner join table alias with id values
SQL
17 votes165 views6 answers
MySQL ORDER BY
SQL
3 votes148 views1 answer
Oracle user privileges
SQL
2 votes146 views1 answer
Sql find not in list
SQL