Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Joined query

Status
Not open for further replies.

sgebbie

Technical User
Joined
Mar 17, 2003
Messages
1
Location
GB
I have a table with 3 fields, SponsorId, Id, Name

I am trying to write a query that'l produce hierarchical data, the problem is the id fields are not sequential nor obvious (1.1.2... more like 15358874 is a child of 55888824)

I am havin real problems because of this, I have 252 records and so far have only been able to export 13 (all from the first element after root), once that subset has finished it doesnt go back to the start and get the next node.

i tried using joins but i just go into infinite loop.
Can anyone give me any help, or sample code, once I can get all elements exported then i can continue with my work

any help would be appreciated
thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top