Re: Nested sort
From: Bob Stearns <rstearns1241_at_charter.net>
Date: Thu, 29 Sep 2005 00:55:27 -0400
Message-ID: <3vK_e.27347$X6.21434_at_fe05.lga>
>
>
>
>
>
>
> order by states,sites,buildings
>
> Sincerely,
>
> Gene Wirchenko
>
Those columns dont exist in my table. Received on Thu Sep 29 2005 - 06:55:27 CEST
Date: Thu, 29 Sep 2005 00:55:27 -0400
Message-ID: <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. Received on Thu Sep 29 2005 - 06:55:27 CEST