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

I figured how to use derived table approach too. I will continue on testing this tomorrow. If I were as young as you, I would stay up late and finish it but those days are gone <g>. Thank you.