Tree walking using two tables
in order to create parent-child relationships, we need to use two tables because some children can have two parents and all parents have more than one children.
this makes tree walking by using the "connect by prior" difficult. has anyone run into something similar and what is the solution?
tia