List:General Discussion« Previous MessageNext Message »
From:Keith Spiller Date:December 16 2006 9:25pm
Subject:Sort Select by List
View as plain text  
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