Re: [SQL] distinct with sum

2006-07-09 Thread Hélder M . Vieira
I need to list products from the table of ordered products with ordered quantities. Each product should be there only once but quantity should be a sum from all the same products from the table. I prepared some query but in quantity column I can see only amount from one record. I need to have su

[SQL] distinct with sum

2006-07-09 Thread mbobi
I need to list products from the table of ordered products with ordered quantities. Each product should be there only once but quantity should be a sum from all the same products from the table. I prepared some query but in quantity column I can see only amount from one record. I need to have su