Hierarchical Query Question
From: Jack R. Sumner Jr. <jrsumner_at_ix.netcom.com>
Date: 1997/01/13
Message-ID: <32DB0FAB.2917_at_ix.netcom.com>#1/1
[Quoted] 301* 302 303 304*
401* 402
Date: 1997/01/13
Message-ID: <32DB0FAB.2917_at_ix.netcom.com>#1/1
[Quoted] [Quoted] Hi. I am having trouble with a hierarchical query and I thought someone out there might have run across this before and be able to help.
[Quoted] I need to be able to start at the top of a hierarchy (100 below) and perform a sum on a column (say PRICE) in each record. The catch is that the summation can only include those records where a flag (represented by the =91*=92 below) is set to TRUE.
100*
200* 201*
[Quoted] 301* 302 303 304*
401* 402
[Quoted] In this example starting at 100, I need to sum up the PRICE column for 100, 200, 201, 301, 304, & 401.
Any ideas on how to do this with a hierarchical query?
Thank you in advance,
Jack Sumner (jrsumner_at_ix.netcom.com)
Received on Mon Jan 13 1997 - 00:00:00 CET