Sort (SQL) Query Results

[grabit]

Hi People
I have a query with the following sql statement:

<cfquery name="showcategories" datasource="#dsn#">  
SELECT fcategories.catID, region, category, description, 
MAX(postdate) AS lastpost, COUNT(threadID) as postCount 
FROM fcategories LEFT JOIN fthreads 
ON fcategories.catID = fthreads.catID 
GROUP BY fcategories.catID, region, category, description 
ORDER BY category ASC
</cfquery>

This returns all results i want ok but i would now like to sort the results also by region.( i have added a column in the fcategories table named region.
Can someone please help with how to do this)?

Cheers & thanks in advance
Grabit

[Delerna]

ORDER BY category,region ASC

[NeoPa]

Line #7 simply needs to include all the fields you want to sort by, in the required order. The ASC part is not really required as it simply specifies the sorting be in ascending order (the default anyway).

ORDER BY category, region

PS. Please see the posting guidelines (Member Registration - Bytes) about how you should go about formulating your question. A meaningful title is a requirement. I have changed this one now to conform to the requirement.

Administrator.