Re: Nested sort
Date: Thu, 29 Sep 2005 09:52:15 -0700
Message-ID: <tr5oj15clvrtplak4cqhtm3rivd2shnunm_at_4ax.com>
On Thu, 29 Sep 2005 00:55:27 -0400, Bob Stearns <rstearns1241_at_charter.net> wrote:
>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
>Those columns dont exist in my table.
It might be time for a redesign then. Sorting by non-existent data is rather tricky. <EG>
Sincerely,
Gene Wirchenko Received on Thu Sep 29 2005 - 18:52:15 CEST