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

20 votes360 views6 answers
Creating a table in sql
SQL
0 vote349 views1 answer
Syntax for changing column size in mysql
SQL
0 vote344 views1 answer
Safe mysql
SQL
4 votes333 views1 answer
Mysql biginteger size
SQL
5 votes374 views1 answer
Oracle add time to date
SQL
1 vote363 views1 answer
Influxdb export to csv
SQL
0 vote388 views2 answers
Insert data mysql with cmd
SQL
6 votes360 views1 answer
Phpmyadmin password root
SQL
0 vote356 views1 answer
Day of the week sqlite
SQL
0 vote360 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL