Hello;
Just an idea ok..

select a.field1,a.date1,;
from table1 a;
join table2 b on (a.field1 == b.field1);
where (date1 <= varDate);
into cursor myCursor