MySQL Forums
Forum List  »  Newbie

Re: Help rewriting subquery
Posted by: Plane Guy
Date: April 28, 2005 02:25AM

Chris,

Thank you VERY much, it works a treat.

You are right, in that I need both details on the parent node, and nested sets in the same table. The parent info was originally just in their at the beginning, for my automated tree traversal function (ie generate the nested lists in the first place), but it is actually quite fortuitous that I didn't remove the column, as it makes queries where I need to take both a top down, and bottom up approach a lot easier (a SQL guru could probably make it work without the parent info, but then they wouldn't be posting in the newbie forum)

So once again. thanks a heap.

Options: ReplyQuote


Subject
Written By
Posted
April 27, 2005 05:30AM
Re: Help rewriting subquery
April 28, 2005 02:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.