The record from table2 should always link to the record in table1 that has the same ID and table1.date1 is less then table2.date2. So to answer your question, Yes,...

Thanks for replying, but the following query will do the trick

SELECT t2.ID

, t2.Date2

, t1.Date1

FROM Table2 AS t2

INNER

...