[Resolved] "Quantity" Count Help in SQL Expression

[Warren Ang]

I'm developing an inventory application. There is a column "Product Name" and a column "Quantity". I wish to group the same product name together to produce a quantity.

What I mean is:

Product_Name

Coke
Coke
Coke

Total of coke is: 3

So I have these expression currently : SELECT Product_Name, SUM ('Inventory'.i duno how 2 continue) FROM 'Inventory' GROUP BY Product_Name

What i wish to do is the statement will group similar product_name's names together and count how many records are repetitve by the similar names.

Thanks in advance.