• 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