|
Gax -> a tough "geneological" Query (2/8/2005 4:13:02)
|
Table = Users
Each record contains a ReferredBy field that tells us who they were referred by.
Bill referred bob, who referred, bill, who referred bubba etc. Some of these can go 20+levels deep.
I want to search by bobs User ID and have it return Bill, Bubba, and everyone else that was a result of his referrals regardless of how many different "generations" it takes.
I have toyed unsuccessfully with some varying methodology. Most of which I really dont like.
Please help.
Gax
|
|
|
|
