>>>I want to JOIN one table with another one. The fields should be joined by date. Instead of the exact date, I want to find a record, in the second table, whose date is closest (<=) to a certain date in the first table. In other words, an exact match may, or may not, exist.
>>>
>>>Can this be done with SQL - SELECT syntax? I was thinking about the workaround of writing a function that gets the PK of the second table, and then use that field for the join. However, I was wondering whether there was a simpler way to do this.
>>>
>>>TIA, Hilmar.
>>
>>Hilmar,
>>
>>Take a look at thread #
550067. This question came up there and the solution was a non-SQL one. (or a combination)
>>HTH
>
>Thank, Crescencio. It seems I need to adapt some ideas from the thread you mentioned, especially message #
550500, by Sergey.
>
>Hilmar.
Well, that message is not from Sergey but a reply to one of his messages on this thread.