InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 12:57:58 GMT20http://www.teradata.com/teradataforum/Topic11379-9-1.aspxI haven't tested... but something like this should work ...WITH RECURSIVE RECTBL(CHLD, PRNT, LVL)AS( SELECT CHILD, PARENT, 1(INTEGER) FROM MYTBL WHERE CHILD = 'G' UNION ALL SELECT MYTBL.CHILD, MYTBL.PARENT, RECTBL.LVL + 1 FROM RECTBL INNER JOIN MYTBL ON RECTBL.PRNT = MYTBL.CHILD AND RECTBL.LVL <= 5 )SELECT CHLD, PRNTFROM RECTBLORDER BY LVL;Thu, 08 May 2008 02:01:25 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11379-9-1.aspxHi All,I'm new to teradata and your help here would be greatly appreaciated.I need a recursive SQL to find the child-parent relationship in a table.For example,Child ParentB AC BD BG CJ ANow i need to recursively find out the parents until a node does not have any parents(I need to do this search recursively for 5 levels)For instance,If i want to trace the parent of child G...it must be like G-->C-->B-->AIf i want to know the parent of G,it must traverse like D-->B-->A.Regards,KumarThu, 08 May 2008 01:02:06 GMTkumar