Re: Nested sort

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 Received on Thu Sep 29 2005 - 02:27:23 CEST