Correct SQL incantation for multiway sorts


#1

What I want to do is sort by status and then sort by priority.

It seems to be that there is a way to do this in SQL, but I’ll be darned if
I can remember the incantation. Can anybody give me an idea, or a link to an
on SQL manual?

Thanks,

– rouilj


#2

What I want to do is sort by status and then sort by priority.

It seems to be that there is a way to do this in SQL, but I’ll be darned if
I can remember the incantation. Can anybody give me an idea, or a link to an
on SQL manual?

you can’t do sub selects in mysql yet (at least last i read -
someone PLS correct me if i’m wrong)

so you’d need to do something like

select from where order by

mysql docs are on http://www.mysql.org

-Jae

"I'm very drunk and I intend on getting drunker before it's over."
			    -Clark Gable, Gone with the Wind