Sum mysql decimal values

Question

I made a query that adds a decimal field, only I’m having trouble, because when I put the clause group by t1.id_sell it lists me sales but no longer sums correctly and without the correct sum clause but only returns me a line.

query:

SELECT Sum(t1.preco_sell) AS result_sum, t1.*, t2.name, t3.name_produto 
FROM   tb_sell t1 
       INNER JOIN tb_user t2 
               ON t1.id_user = t2.id_user 
       INNER JOIN tb_produtos t3 
               ON t1.id_produto = t3.id_produto 
WHERE  t1.status = 2 
GROUP  BY t1.id_sell 

Answer 1

The problem lies in yours in the fields you display in your Select, at its junction on Group By

If you wanted to display the sum of all items sold in a new column, what you should do is a Subquery for that reason

SELECT t1.*, t2.name, t3.name_produto,
(SELECT Sum(preco_sell)
    FROM   tb_sell
    WHERE  status = 2
)AS result_sum
FROM   tb_sell t1
       INNER JOIN tb_user t2
               ON t1.id_user = t2.id_user
       INNER JOIN tb_produtos t3
               ON t1.id_produto = t3.id_produto
WHERE  t1.status = 2

When you order display all items from t1 the query will not be able to group, since all fields probably have different values and this is not returning what you want