>>It depends on what exactly do you want to get. If you want to get the related record's info, then check these blog posts:
>>
>>
Optimizing TOP N per Group Queries - blog by Itzik Ben-Gan explaining various optimization ideas
>>
>>
Including an Aggregated Column's Related Values - Erik and mine blog presenting several solutions of the problem with explanations for each
>>
>>
Including an Aggregated Column's Related Values - Part 2 - my blog post with use cases for the previous blog
>
>I read (very quickly) one of your blogs and really liked how correlated subquery can be applied to my case. It even eliminates the need for HAVING clause (that I was never really comfortable). I created a simple test with the correlated query and seems to return correct results. Thank you very much. Do you want me to post my test/sample SQL Select so that you can take it apart? <g>.
It's up to you. I do like derived table approach, also, it's portable in VFP9.
If it's not broken, fix it until it is.
My Blog