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 vote106 views1 answer
Sql server udf performance
SQL
0 vote104 views1 answer
How to check if there is no database schema
SQL
0 vote104 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote111 views1 answer
Mysql select row with min date
SQL
0 vote120 views1 answer
SQL: calculate hours from two dates
SQL
0 vote99 views1 answer
Export partttion and import in oracle
SQL
1 vote121 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
16 votes101 views4 answers
Sort by sql
SQL
0 vote120 views1 answer
Mysql get first 2 characters of string
SQL
0 vote100 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL