At 10:07 AM 6/27/2008, you wrote:
Hi Ananda,The query is for reporting purposes and I would like to include a date range for the user to report on. That part of the query has to be there for it to work nicely. Regards, Darryl
Darryl,Your Where Clause uses a date expression on the column so it has to scan all the rows that satisfies the date range.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]