Re: SELECT & recursion

I have a table in which each record [sic] describes an object. Each object [sic] had a unique name <<

Row are not records --not even close. Next, we do not keep objects in
tables; SQL is a set-oriented model of the world. A set of made of
things of the same kind. I hope you are nto confusing OO with RDBMS,
but it sounds like it.

After saying all of this, get a copy of TREES & HIERARCHIES IN SQL; I
wrote whole book on this topic.
..

.

Relevant Pages