distinct with sum

[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 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 sum there.

The query:
select distinct on (id_prod) id_prod, id_unit, sum(quantity) as result from products where determinant = false group by id_prod, id_unit

Thanks in advance for your help.

 

[feherke]

Hi

I would not predict to much success for that statement. Better use only [tt]group by[/tt] without [tt]distinct[/tt].

Feherke.

http://rootshell.be/~feherke/