List:General Discussion« Previous MessageNext Message »
From:Keith Spiller Date:December 16 2006 9:35pm
Subject:Re: Sort Select by List
View as plain text  
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
Thread
Sort Select by ListKeith Spiller16 Dec
  • Re: Sort Select by ListKeith Spiller16 Dec
  • Re: Sort Select by ListPintér Tibor16 Dec
    • Re: Sort Select by ListMark Leith16 Dec
      • Re: Sort Select by ListDan Nelson17 Dec
        • Re: Sort Select by ListDan Nelson17 Dec
          • Re: Sort Select by ListMark Leith17 Dec
  • Re: Sort Select by ListKeith Spiller17 Dec