Sorting Help Needed!

[kamy99]

Hi all:

I need to organize my query results based on two columns, is that possible?

I have a table of members, with membership type.
I wanna sort them by membership first, then within each membership ordered by last name.

I do know how to do this individually:

SELECT * FROM members ORDER BY membership
SELECT * FROM members ORDER BY lastname

But I don't know how to mix them.

Any ideas?

Thanx
Kamy

[kamy99]

I think I got it myself!

SELECT * from members ORDER BY membership DESC, lastname ASC

🙂

[Jasp182]

SELECT * FROM members ORDER BY membership, lastname