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 vote179 views1 answer
Sql grant select only
SQL
11 votes180 views2 answers
How to import mysql database command line
SQL
10 votes160 views1 answer
Create table oracle
SQL
0 vote161 views1 answer
RowDataPacket
SQL
0 vote210 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
5 votes180 views1 answer
Sql table columns
SQL
1 vote170 views1 answer
Psql show with user is logged in
SQL
0 vote192 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote165 views1 answer
Renombrar tabla mysql
SQL
0 vote170 views1 answer
Delete first row in sql
SQL