Hi Hal,
I appreciate your help, but the order can not be alphabetical.
It must be explicitly Exec, VP, Dir...
Keith
----- Original Message -----
From: "Hal Wigoda" <[EMAIL PROTECTED]>
To: "Keith Spiller" <[EMAIL PROTECTED]>
Sent: Saturday, December 16, 2006 2:28 PM
Subject: Re: Sort Select by List
order by office
On Dec 16, 2006, at 3:25 PM, Keith Spiller wrote:
Hello,
RE: Sort Select by List
I'm wondering how I would turn three different queries:
SELECT * FROM team WHERE office = 'Exec'
SELECT * FROM team WHERE office = 'VP'
SELECT * FROM team WHERE office = 'Dir'
Into one query with the sort order of office = 'Exec', 'VP', 'Dir'...
Thanks,
Keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]