I have a recursive looping problem here. For example, say I have this table
id, name, parent 1,john,4 2,bill,3 3,cathy,4 4,jackie,0 5,jeff,4 6,joe,7 7,amy,0 Essentially, jackie doesn't have a parent, but has john, jeff and cathy as children. bill is the child of cathy and thus jackies grandchild. How would I do this query such that I say I want to see all the children (including everyone below him/her) below, say jackie...this is really a self join to oneself with an unknown number of levels below. How would I do this in jsp do display all of jackies relatives below her? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com