Union Select sorting
From: Gerald Stanley (gcstanley_at_d-s-l.pipex.comREMOVE-)
Date: 05/28/04
- Next message: Shawn: "Date Search"
- Previous message: Tara: "Option group selection as query criteria"
- In reply to: JR: "Union Select sorting"
- Next in thread: Van T. Dinh: "Re: Union Select sorting"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 May 2004 08:05:43 -0700
The Help file speaks the truth. The ORDER BY clause can
only relate to the columns output as it references the
column names assigned (either explicity or implicitly) in
the first part of the UNION. You will have to include your
hidden column if you wish to sort by it.
Hope This Helps
Gerald Stanley MCSD
>-----Original Message-----
>I'm having trouble sorting a Union Select query. I would
like to sort on a hidden field, but from what I've read in
help the only 'order by' field that I can add has to be one
that is selected in both queries that I'm joining.
>
>Suggestions?
>
>Thanks for your help
>
>
>
>.
>
- Next message: Shawn: "Date Search"
- Previous message: Tara: "Option group selection as query criteria"
- In reply to: JR: "Union Select sorting"
- Next in thread: Van T. Dinh: "Re: Union Select sorting"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
