-
display a family tree
Given the following table regarding family tree:
tree_id child_id parent_id
1 a null
2 b a
3 c b
4 d b
5 e c
6 f d
7 g f
need to display in a hierarchic output:
a - b /c - e
d - f - g
What is the best way to query it?
Thanks in advance.
-
display a family tree (reply)
Hi
I give my students a similar problem during my SQL classes (organisation chart). The best answer: use VB or Delphi! A pure SQL solution? Write a recursive stored procedure ...
Dale
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|