SQL Sort ORDER by 2 different fields for sports standings table

[Gumbocat]

I'm having a problem with an SQL statement on a windows server running IIS 5 using ASP/VB/MSAccess sports web page sorting the standings table.

Here's the statement:

sql = "SELECT * FROM standings ORDER BY pts, pf DESC;"


Standings Table looks like this:

Team Games Pts Pf
Hornets 3 3 5
Cats 3 3 10
Wilds 3 3 8
Hogs 0 0 0


I'm trying to query the table to give me the following output sorted by Pts and Pf:

Team Games Pts Pf
Cats 3 3 10
Hornets 3 3 5
Wilds 3 3 8
Hogs 0 0 0




Instead it gives me this format:
Team Games Pts Pf
Hogs 0 0 0
Hornets 3 3 5
Wilds 3 3 8
Cats 3 3 10


Any help would be appreciated.

 

[r937]

ORDER BY pts DESC, pf DESC

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)