On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen <[EMAIL PROTECTED]> wrote: > I suspect mysql is doing the DISTINCT before the ORDER BY. One of the > reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the very last operation, after any selection and projection, doesn't it? Regards Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]