Vince Teachout wrote:
> Actually, if you have VFP9, you can do it with one query:
>
> SELECT A.Rider, A.dDate, A.nScore, ;
> (Select SUM(nscore) FROM foobar B WHERE b.rider = a.rider) ;
> FROM foobar A;
> ORDER BY 4 desc,1
>
I have VFP9, but I started this project before I got it.
--
Regards,
Chester Friesen
Friesen Computer Company
Willows, CA
©2007 Chester Friesen |
