> How would one display all available products and departments in a > recursive navigation inside a recursive query? I like this method, which would allow you to do this in a single query: http://www.sitepoint.com/article/hierarchical-data-database You could probably do it in a single query with your current structure, but it would require a *lot* of looping. -- sarah adams web developer & programmer portfolio: http://sarah.designshift.com blog: http://hardedge.ca