Thanks James! James Holmes wrote: > This is a good summary of SQL useful in this situation: > > http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf > > On 5/18/07, Rey Bango <[EMAIL PROTECTED]> wrote: >> Guys, its been awhile since I've done tree/hierarchical SQL manipulation >> so I need some help. The data looks something like this: >> >> parent_member_id member_id Level >> 1 2 1 >> 1 3 2 >> 2 4 1 >> 3 5 1 >> 4 6 1 >> 4 7 2 >> >> In this scenario, I would be trying to find all downline members of a >> specific parent id. For example: >> >> If I wanted to see all downline members for parent_member_id 1, it would be: >> >> 2,3,4,5,6,7 >> >> If I wanted to see all downline members for parent_member_id 2, it would be: >> >> 4,6,7 >> >> If I wanted to see all downline members for parent_member_id 3, it would be: >> >> 5 >> >> If I wanted to see all downline members for parent_member_id 4, it would be: >> >> 6,7 >> >> Any guidance on this would be helpful. I've tried Googling this but to >> no avail. >> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
