hello!! I have this situation, and don't know how to solve it... My table:
ID ORIGINAL_ID ==================== 1 NULL 2 1 3 2 4 NULL 5 1 So, the ID 1 has two children (2 and 5) and 2 has one children (3). Of course, ID 3 could have N children and so on... What I need is to select all the descendants of a given record. For instance, I want to select all the records related to ID 1, I would have: ID ORIGINAL_ID ==================== 1 NULL 2 1 3 2 5 1 It sounds that I should use recursion, but I can't figure out how... Thank you very much!!!! Sergio. [Non-text portions of this message have been removed]