List:General Discussion« Previous MessageNext Message »
From:Pintér Tibor Date:December 16 2006 9:53pm
Subject:Re: Sort Select by List
View as plain text  
Keith Spiller írta:
> 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
>   

order by right(office,1)

or make an extra column for ordering

t
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