Multi Categories search

Hi,

I have defined 3 trees categories, the roots are Service, Country and Directory Type. This 3 kinds of roots in the categories have their own multi level children. Each directory can select multi services with multi country with multi directory type.

How can I setup with following criteria
1. Treeview multi select checkbox for each root and children?
2. For search sql statement, use “OR” within each tree, and use “AND” between tree node. For example, select * from geodirectory where (category = “Service A” or category = “Service B”) and category = “Country A” or category = “Country B”)?

Thanks a lot!