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

Jae jgangemi at pwebtech.com
Thu Mar 16 10:26:40 EST 2000

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


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

More information about the Rt-devel mailing list