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 vote206 views1 answer
Postgres regex remove special characters
SQL
0 vote236 views1 answer
How to check rollback status in oracle
SQL
0 vote194 views1 answer
Timestamp(0) postgresql
SQL
0 vote182 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
7 votes192 views2 answers
MySQL IF without else
SQL
10 votes208 views6 answers
Between sql
SQL
4 votes219 views1 answer
Describe table mysql
SQL
6 votes182 views4 answers
Delete table sqlite
SQL
0 vote209 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
1 vote201 views1 answer
How to see all table partition in oracle
SQL