Hi, Maciej > > I didn't find a SQL solution to this problem. >
Now Flink provides the SQL solution, you can see the doc[1], the Flink-1.12 document link that posted by Chesnay should have updated but not..., I’ll check the document of 1.12. Best, Leonard [1] https://ci.apache.org/projects/flink/flink-docs-master/dev/table/streaming/joins.html#event-time-temporal-joins <https://ci.apache.org/projects/flink/flink-docs-master/dev/table/streaming/joins.html#event-time-temporal-joins>