Maryam
04/21/2023, 3:41 PMMaryam
04/21/2023, 4:07 PMSELECT *
FROM Table1
LEFT JOIN Table2
ON Table1.key = Table2.key
AND Table2.timestamp BETWEEN Table1.timestamp - INTERVAL '5' MINUTE AND Table1.timestamp + INTERVAL '5' MINUTE
Is it possible for a key from the left and right tables to be one minute apart but not joined because they fall into different windows if windows are created first.