Mailing List Archive: Correct SQL incantation for multiway sorts.

On Wed, 15 Mar 2000, Rouillard, John wrote:

> 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 <fill in> from <fill in> where <fill in> order by <fill in>

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