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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
