Child and Parent Relationship

Results 1 to 2 of 2

Thread: Child and Parent Relationship

  1. #1

    Default Child and Parent Relationship

    I have two columns in a table, ID and a Parent ID.<BR><BR>Now For a parent ID i want to retrieve all the ID under that <BR>Parent ID.<BR>Even the ID also be a parent ID with a child under it. <BR>So i want to retrive all the childs till the last child.<BR><BR>I need to do a recursive stored procedure to retrieve all the IDs under it for any selected Parent ID<BR><BR><BR>Venkatesh.R<BR><B R>

  2. #2
    Join Date
    Dec 1969

    Default RE: Child and Parent Relationship

    sounds like you just need joins, or perhaps data shaping<BR><BR>joins :<BR><BR><BR>(something to do with scooby doo)<BR><BR>data shaping :<BR><BR><BR><BR>j<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts