Hi all -

I need to run some reports from the database, and finally figured
out that LC_TallyProduct contains the discovered products. The problem
is that it also contains suite components, as well as the suites
themselves. For instance, it has "Word 2003" and also "Office 2003" --
so it's like I'm reporting the same software twice.

My question is - how can I report all the discovered products,
excluding suite components, but including the suites/software
collections themselves? Has any one written this in SQL yet? Or does
anyone know who I should link the tables?