Noel Stratton: > As you can see the summary total in the 'Total' column is incorrect. The > summary total should be 36 but is spitting out 40. I am not even sure > where it is getting 40. The only way to get 40 is if it is multiplying > 5X8.
Isn't that what you told it to do? > ROUND(price*count(log.product), 2) AS 'Total' For the summary line that means "Pick a price field at random (as there are several rows to choose from) and multiply it with the count of all the log.product fields." Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
