No. With the method you're using (storing the parent id with each record)
you have to use a recursive series of queries to show the subtree levels.
Take a look at this article--especially the second and third pages about the
modified preorder tree traversal and nested sets. There are many other
articles on this, but I found this one especially helpful starting out. It
will let you do what you want, but this method has its drawbacks too.
Let the new MSN Premium Internet Software make the most of your high-speed
|• Query help||Andrew Barnes||28 Jan|
|• re: Query help||Jeremy March||28 Jan|