Thread: category and brand combination questions

Anybody have a sql script that will allow us to
create a report that shows
how many brands are in each child category.

What I mean is this. We currently have 250 or so child category.
Each child category has any where from 4 to 14 brands associated with it.

This could just be as simple as cross referencing the
productID from the ProductCategory table with categoryID
and then cross reference the ProductID from
ProductManufacturer with the ManufactureID

After that include the category ID name from Category table and
also include the manufacture name as well

so the table should look something like this


Child Category Name Manufacture
Round Toilet Seat American Standard

I want to see how many combinations I have.

thanks for your help.

Please note, I could have over thought this process, if there is an easier way, then be my guest.

Code:

select distinct c.name as category, m.name as brand
from Category as c with (nolock)
join ProductCategory as pc with (nolock) on pc.CategoryID = c.CategoryID
join ProductManufacturer as pm with (nolock) on pm.ProductID = pc.ProductID
join Manufacturer as m with (nolock) on pm.ManufacturerID = m.ManufacturerID

Exactly what I was looking for.

Thank You