[rt-devel] Correct SQL incantation for multiway sorts.

[Jae]

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