* [EMAIL PROTECTED]
[...]
> Aha, now I have SUM(ROUND(how_much,2)), this works so far.

You should swap these two function calls, the way you are doing it you are
summing up the rounded values, instead you should round the sum of the
values: ROUND(SUM(how_much),2)

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to