Sql period overlap

This article is tagged with: Sql period overlap and mysql

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)

This article is tagged with: Sql period overlap and mysql