>>Thank you William.
>>
>BTW, there are other ways to get the same information, but this one is the simplest to remember.

"Simplest" is very subjective and depends upon how one "grew up" with SQL. I think the pre-VFP9 version

SELECT * FROM Table2 WHERE date IN (SELECT MAX(Date) AS Date FROM Table1)

is simpler to remember. I will accept that the more "modern" code is "better" and may run faster, etc. but simpler, like beauty, is in the eye of the beholder.