What is a simple and efficient way to find rows with time-interval overlaps in SQL?

SELECT * 
FROM table1,table2 
WHERE table2.start <= table1.end 
AND (table2.end IS NULL OR table2.end >= table1.start)