Hi Sarav,
I am not sure how you structured your tree. I presume you use the parent as
a foreign key. Then, I see no way how you can read in the complete tree
with a join because you have the one-to-many relation of B with itself.
Therefore, the depth of your tree is not limited and also the n
Hi,
I have 3 tables A, B and C. A has a one-to-many relationship with B
_and_ C. B has a one-to-many relationship with itself _and_ C.
For example (ASCII art tree - fixed width font will help) the following
is a valid tree that I'm trying to represent with the tables A, B and C-
A