order by

[QuintonV]

Hi

Is there anyway to order by more then one field in mysql?
I want to order by the key field and another field which has dates , in laymans terms by multiple fields not just one also can they hav difrent orders ie asc and others desc?

 

[smedvid]

In the words a former co-worker used to use: RTMF... read the manual first... Search Access Help on ORDER BY Clause.

Example:
SELECT ClassList.CourseID, ClassList.CourseStartDate, ClassList.CourseLocCode, ClassList.Last4SSN
FROM ClassList
ORDER BY ClassList.CourseID, ClassList.CourseStartDate DESC, ClassList.CourseLocCode;

A tip to learn SQL is to use the Query Design view and then review the SQL used to construct the query....

Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/