Dan: This has potential! Reminds me of those cartesian joins that I think we all learned first from Bill & David's book. I need to sit down and "convert" this to RBase-ease so I can understand it better.
Karen In a message dated 3/22/2012 6:38:18 PM Central Daylight Time, [email protected] writes: > SELECT P_2.MemberName, Exp(Sum(Log(P_1.Qty))) AS RequiredQty > FROM P, P AS P_1, P AS P_2 > WHERE (((P.MemberID)=[RootNodeID]) AND ((P_1.lft) Between [P].[lft]+1 And > [P].[rgt]) AND ((P_2.lft)=[P_2].[rgt]-1 And (P_2.lft) Between [P_1].[lft] > And [P_1].[rgt])) > GROUP BY P_2.MemberName >
