I have been reading that it is not necessary to sort the table? Is that true. I was thinking of sorting the table by AgeGroup/event/avgscore and then outputting the table as an xml/json file which can then be read by the app software? I can sort the data with this in the query
SELECT FirstName, LastName, AgeGroup, CompNumber, event, avgscore, bscore
FROM WomenResults
ORDER BY AgeGroup, event, avgscore DESC;
but the table has the data just as it was in the file. The goal is the separate the athletes so the parents can view scoring by their daughters agegroup.
Tim