Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query help: with root, find all child nodes
Message
From
05/12/2004 01:41:09
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Query help: with root, find all child nodes
Miscellaneous
Thread ID:
00966953
Message ID:
00966953
Views:
53
Hello,

I have a relationship between parent and child nodes as such.

The - indicates related to

A - B, C
B - D,E
D - F
C - J,H
E - G

What I am trying to accomplish is to write a query that will be supplied a root value.. ie A and I want to find the downlines..
Therefore, all the alphabets you see in the list above should appear..

I hope this is enough info.

I am in process of writing this query.. any help is appreciated.

Alvin
Next
Reply
Map
View

Click here to load this message in the networking platform