ORDER BY in query

Is there any way to order a query on a secondary level? Here is my current query...
<cfquery name = "results" datasource = "#request.dsn#">
SELECT *
FROM results
WHERE round_#this_round# IS NOT NULL
ORDER BY total_score DESC
</cfquery>
which orders the results query by total_score (a numeric field). However, in certain situations there is more than one team tied on the same score. When this happens I want to order alphabetically by team_name (a text field). Any ideas?

TIA
Mark

you can build up your order by's by writing them as a comma delimited list.

you should really look for a good SQL book , this would have been coverd in the basics.


<cfquery name = "results" datasource = "#request.dsn#">
SELECT *
FROM results
WHERE round_#this_round# IS NOT NULL
ORDER BY total_score DESC, team_name DESC
</cfquery>