Cindy recognized that VFP won't support TOP in a nest subquery - quite a shame actually.
Your query returned 5 rows because there was a tie in the last position. Technically the answer is correct but how you want to handle it from a business POV could be completely different.
-Mike