No, didn't test in VFP (don't have it installed locally). I guess it's too bad and it is not going to work in VFP.
>Naomi,
>
>did you test the statement? I get error "Invalid use of subquery"
>
>with :
>
>select score , team ;
> from crResult as A1 ;
> where (select count(*) from crResult as A2 where A2.team=A1.team and A2.score<=A1.score ) <=2 ;
> order by score
>
>Regards,
>
>Koen
>
>P.S. My testdata consists of CREATE CURSOR crResult (team c(4), score n(2,0)) with values as per example given
If it's not broken, fix it until it is.
My Blog