Ordering by two things

[jc94062]

I have a SELECT statement...

ORDER BY table1.position DESC

which works fine, but is it possible to order alphabetically within this. So when position is the same, and entries with the same value for position are sorted alphabetically by name.

ie

ORDER BY table1.position DESC AND table1.name

If your wondering, I'm useing table.field type syntax cause I'm joining two tables.

From everywhere I've looked it doesn't seem possible, but there must be someway I'd think,

Thanks for any feedback.

[kparker]

Sure you can. The syntax is:

ORDER BY table1.position DESC, table1.name

[jc94062]

Brilliant, works great, thanks loads 🙂