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 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings