How to select only the first values ​​from a table?

Question

SQL

How to implement a join of two tables without using complex built-in functions in such a way that the date from the first and the date from the second are compared, all values ​​from the first and from the second are taken, only those in which the date is closest to the date from the first table

Answer 1

The question is about nothing, let's give the structure and description of the tables.