>>>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.

The code above is not correct.

When I was coming home I was thinking I should write a FAQ on this topic since it's a commonly asked question. I thought it through, but I don't think if I can find the time to actually do this.