>>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 WHEREdateIN (SELECTMAX(Date) ASDateFROM 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.