Order By Clause - can I sort by multiple columns

[techkate]

Tried searching previous posts but to no avail.

Is it possible to use the Order By clause to sort by more than one field? If so, what is the syntax for this?

The simplest example that gets my point across:

SELECT * FROM [Customers]
[i]ORDER BY [Last Name], [First Name][/i]

Thanks for your time.

 

[lespaul]

there's nothing wrong with that. Is it not sorting correctly? With that sort order I would expect to see:

Anderson, Anna
Anderson, Bill
Andrews, Alba
Andrews, Leslie
Andrews, Pat
Billings, Bob
Billings, Mary

is that not the results you are getting?

leslie

 

[techkate]

Oops sorry...you're right that is the correct syntax. I guess it is just one of those days. Thanks for your input though, otherwise I would have been chasing a ghost.