tag:blogger.com,1999:blog-757209515540162326.post4985992002225098464..comments2010-03-22T10:50:02.255-05:00Newslackerhttp://www.blogger.com/profile/03817274309191238681noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-757209515540162326.post-88595090419121589492010-03-22T10:50:02.243-05:002010-03-22T10:50:02.243-05:00Thanks a lot. Helped me quite a lot because i have been trying to make a query work for more than 2 hours before I found this piece of codeCyberWolf08http://www.blogger.com/profile/15313389100620524665noreply@blogger.comtag:blogger.com,1999:blog-757209515540162326.post-15041166712109143002009-08-07T00:33:48.627-05:002009-08-07T00:33:48.627-05:00Yeah, the First one searches towards the leaves of the tree (returning all children of the given record), commonly known as &quot;down&quot; and the second one searches towards the root (returning parent, grand parent, great grandparent etc of the given record) commonly &quot;up&quot; the tree.<br><br /><br><br />Very handy, thanks a lot!Michaelnoreply@blogger.comtag:blogger.com,1999:blog-757209515540162326.post-72823347364071374372009-04-16T14:17:00.000-05:002009-04-16T14:17:00.000-05:00Nice post! Thanks. Although isn't it 1) down the tree and 2) up the tree..Anonymousnoreply@blogger.com