display a family tree

[Rachel]

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.

[Dale Shaw]

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