Re: recursive query in a product catalog tree?

[Jay Pipes]

peter michaux wrote:
> Is there a single step query that will do this?

Yes, but only if you have already determined the depth of the tree. And that query is quite cumbersome. If you want fast, efficient, tree-based SQL, use the nested set model, made popular by Joe Celko. Mike Hillyer has written a good tutorial on this in MySQL, and it is also covered in my book. (I know, blatant self-promo). I would explain it here, but it's involved and would consume quite a bit of time :)

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com