Re: Nested sort
From: Bob Stearns <rstearns1241_at_charter.net>
Date: Wed, 28 Sep 2005 18:48:12 -0400
Message-ID: <L6F_e.26323$X6.17287_at_fe05.lga>
Date: Wed, 28 Sep 2005 18:48:12 -0400
Message-ID: <L6F_e.26323$X6.17287_at_fe05.lga>
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?
>
>
> Hi Bob,
>
> Sure!
>
> SELECT NAMEX
> FROM IS3.LOCATIONS
> WHERE whatever your current where clause is
> ORDER BY NAMEX
>
> Best, Hugo
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.
Received on Thu Sep 29 2005 - 00:48:12 CEST