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 [EMAIL PROTECTED] [EMAIL PROTECTED] Web : http://devrim.oper.metu.edu.tr ------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster