A SQL Training

Hi,

Today, one of my teacher asked me a question for a practice... I could not
solve it :)

Here it comes:

We are given the name of the grandfather in a family. Let's call him A. A
has n sons, each son has children .

for example.
A -> Grandfather
/ \
/ \
B C
/\ / \ \
/ \ D E F
G H
...

We are given the data like ('A','B'),('C','D')...

Now, we do not know how many children are in the list. How could we list
this family tree in "tree" formt by only using SQL?

Best regards.

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr

Web : http://devrim.oper.metu.edu.tr
-------------------------------------