I have a mySQL database of individuals who do several different activities at various start dates in the year. I need to sort all the data by start date. But because each record contains several activities and associated start dates, how can I best extract this data for sorting?
For example, a typical record...
I want to sort all the activities by their StartDate and be able to access the associated Name and Address etc.