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 vote139 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote275 views2 answers
Create fulltext index mysql
SQL
0 vote155 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote167 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote130 views3 answers
Getdate function in postgresql
SQL
1 vote132 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote131 views1 answer
Char varchar nvarchar sql
SQL
1 vote133 views1 answer
Oracle lowercase
SQL
19 votes135 views6 answers
What is mySQL
SQL
31 votes144 views3 answers
Sql count
SQL