I appreciate your help, but the order can not be alphabetical.
It must be explicitly Exec, VP, Dir...
----- Original Message -----
From: "Hal Wigoda" <hwigoda@stripped>
To: "Keith Spiller" <larentium@stripped>
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:
>> 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'...