On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can achieve this with the WITH ROLLUP option of GROUP BY. Although you
would probably have to perform a trick on the "date" column to have the NULL
value that WITH ROLLUP would return to return as "total" - i.e
IFNULL(date,'Total') as a quick (and dirty) example, as this doesn't work
too well o
