Quich Question on ORDER BY

[BJ Duncan]

I am aware that you can 'ORDER BY' 2 different values
E.G. ORDER BY name, surname

But, can you 'ORDER BY' 2 different values and have them ordering in different directions

E.G ORDER BY group_id ASC, total DESC?

Does this work? If not, how can I make it work?

Many thanks in advance

[Ruben K.]

What do you expect it to do?

[BJ Duncan]

My apologies Ruben, you can disregard my question as I have finally successfully worked it out. I was doing a query that wasn't working. I thought it may have something to do with the way I was ordering it, but it wasn't, I had some other error within my query, but it is all sorted now.

Thanks anyway

[antid2]

umm, what are you tryin to do?

[BJ Duncan]

I was joining 2 tables and I wanted results to show in order from the group that a user was in first with the group number going from 1 -> 3, then from that group order the group by their total points, from highest scorer to least scorer.

Thanks anyway

[Dr John]

I am aware that you can 'ORDER BY' 2 different values
E.G. ORDER BY name, surname

But, can you 'ORDER BY' 2 different values and have them ordering in different directions

E.G ORDER BY group_id ASC, total DESC?

Does this work? If not, how can I make it work?

Many thanks in advance

YES