Count on composite keys

[rigobertocorrales]

Hi:
I have the following table containing ingredients of products:

IngredientsInProducts(ProductId, Ingredient_Category, Ingredient_Id) The 3 attributes are PK

How could I count all the ingredients (Ingredient_Category and Ingredient_Id) that appear on the table?. Eg
-----------------------------------------------
Ingredient_Category --- Ingredient_Id --- Count
01 001 10
02 099 3
...
-----------------------------------------------

Thanks

 

[LKBrwnDBA]

Did you try using the COUNT() aggregate function?



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[PHV]

This seems like a very simple aggregate query:
SELECT Ingredient_Category, Ingredient_Id, COUNT(*)
FROM IngredientsInProducts
GROUP BY Ingredient_Category, Ingredient_Id

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rigobertocorrales]

You were right dudes:

Solved with the code of PHV. The trick was in Count(*)

Thanks