>I think I could pull this off if you show me how to separate the steps:
>
>Do the first (inner) select into a cursor and then join with that cursor.
>
>My bible for sQL was the FoxPro Programmers Reference and VFP 9's help.

select Account, max(mRating) as MaxRatingForAccount from Ratings GROUP BY Account ORDER BY Account INTO CURSOR csrMx NOFILTER

BROWSE && Just to view the result - comment this later

select R.* from Ratings R INNER JOIN csrMx AS Mx 
ON R.Account = Mx.Account and R.mRating = Mx.MaxRatingForAccount