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" <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:
>
>> 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
