Re: Nested sort
Date: Thu, 29 Sep 2005 14:30:17 GMT
Message-ID: <ZTS_e.5555$vw6.3287_at_newsread1.news.atl.earthlink.net>
"Bob Stearns" <rstearns1241_at_charter.net> wrote in message
news:3vK_e.27347$X6.21434_at_fe05.lga...
> Gene Wirchenko wrote:
> > On Wed, 28 Sep 2005 18:48:12 -0400, Bob Stearns
> > <rstearns1241_at_charter.net> wrote:
> >
> >
> >>Hugo Kornelis wrote:
> >>
> >>
> >>>On Wed, 28 Sep 2005 18:00:45 -0400, Bob Stearns wrote:
> >>>
> >>>(snip)
> >>>
> >>>
> >>>>is there (relatively) easy
> >>>>way to present the data in a sorted manner?
> >
> >
> >>>Sure!
> >>>
> >>>SELECT NAMEX
> >>>FROM IS3.LOCATIONS
> >>>WHERE whatever your current where clause is
> >>>ORDER BY NAMEX
> >
> >
> >>That is too easy, I know how to do that. I want a nested sort. All the
> >>first level locations in order(states), the second level within them
> >>sorted(sites), the third level within them sorted (buildings), etc.
> >
> >
> > order by states,sites,buildings
> >
> > Sincerely,
> >
> > Gene Wirchenko
> >
> Those columns dont exist in my table.
Is there a table of buildings that you can join with the data in your table? Received on Thu Sep 29 2005 - 16:30:17 CEST