SQL Statment

[webhay]

Hi, I have table with 5 column I need to group the duplicate recorde and sum the quantity. And this my table column Product Quantity price description How can i do that? Thank you sms

[John ph]

webhay wrote:

I need to group the duplicate recorde and sum the quantity. And this my table column Product Quantity price description How can i do that?

Select Product, SUM(Quantity) Quantity From tblProducts Group By Product

Regards
J O H N :rose:
"Even eagles need a push." David McNally

---