Count',
ROUND(price*count(log.product), 2) AS 'Total' FROM products LEFT JOIN log ON
products.product= log.product
-Mensaje original-
De: Noel Stratton [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 10 de Noviembre de 2005 04:36 p.m.
Para: mysql@lists.mysql.com
Asun
Noel Stratton wrote:
more thing that I can not figure out. I would like to sum all calculations
created out of the "Total Amount Owed" field that was created.
Noel,
Take a look at the WITH ROLLUP modifier of GROUP BY [1]. This is
available since version 4.1.1.
Regards, Jigal.
[1] http://d
