Post reply

Order By list order

  • March 7, 2005 at 12:36 am

    #164803

    Can I get a SELECT to return results in the order of an external list?

    For example:

    SELECT etc

    WHERE GuestID IN (guestlist)

    ORDER BY same order as guestlist

    Doug

  • March 7, 2005 at 12:57 am

    #545659

    Hi,

    Did you try to use derived tables to achieve this.

    select etc

    from tablea a, (select guestid, name from Guest order by guestid) as b

    where a.GuestId =b.guestid

    order by b.guestid

     

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • March 7, 2005 at 1:08 am

    #545661

    Yes, that's the answer !

    Thanks so much for your help.

    Doug

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply