[Resolved] [Resolved] Sql - Order By

[fean0r]

I cant seem to find anything on this...

Can you select ORDER BY in the below fashion?

ORDER BY Leader, Deputy, Member

Returning Leader is first, Deputy second and Member third?

Thanks

[laserlight]

ORDER BY refers to a column, not a particular series by which to order by.

Of course, that doesnt prevent you from assigning numerical values in some way related to these appointments/ranks, and ordering by that.

[fean0r]

Thanks, I might try a longer work around as I'm too far in to change those values.

Maybe just do 3 querys.

Thanks for the quick response.