[ic] SQL query returning to tree structure

[Jim Boyer]

I have seen some talk in the archives about doing what I need, but nothing 
specific, so I will try to ask specifically.

I am using IC 4.9.5 with MySQL and I am using a tree menu.  I have 
implemented items in multiple categories by creating a table that has the 
sku and the category for each product (sku_category).  I would like to run 
a query that will return to the tree menu similar to the following.

select products.sku from products, sku_category where
products.sku = sku_category.sku and sku_category.category = 'Food'

How do I get this type of query working with the tree menu?

Is there a better way of doing multiple categories per product?  My 
category names have commas, so a comma delimited search won't work.

Thanks for any help you can shed on my problem.

---------------------------------------------------------------
Jim Boyer
Systems Programmer
Information Dept
College of Agriculture and Home Economics
Washington State University