Re: Nested sort


"Bob Stearns" <rstearns1241@xxxxxxxxxxx> wrote in message
news:3vK_e.27347$X6.21434@xxxxxxxxxxx
> Gene Wirchenko wrote:
> > On Wed, 28 Sep 2005 18:48:12 -0400, Bob Stearns
> > <rstearns1241@xxxxxxxxxxx> 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?




.