On Jan 10, 2008 5:40 PM, Eben <[EMAIL PROTECTED]> wrote: > I want to be able to do count of the total records brought back by this > query... but since I am using the group by I can't use COUNT() in the > desired way.
Assuming what you want is all the data from your current query plus an additional row showing a full count, you can use WITH ROLLUP to get it. Or just do a separate COUNT query without the GROUP BY. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]