| Round-the-cans Rankings (Helm) |
| Rank | Name | Points |
SELECT People.personID as PersonID, People.FirstName as FirstName, People.LastName as LastName, SUM(Regattas.Competitors-Races.Position+1) AS Rank FROM Regattas, People, Races, Events WHERE People.PersonID = Races.HelmID AND Regattas.RegattaID = Races.RegattaID AND Events.RegattaID = Regattas.evtID AND Regattas.Races > 1 AND SailorRating = 'true' AND Events.StartDate >= '01/01/2008' Group by People.FirstName, People.LastName, People.PersonID ORDER BY RANK DESC| 1 |
Henry White |
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/nmoreresults.asp, line 109
| |