1 message in com.mysql.lists.mysqlsql syntax question
FromSent OnAttachments
Hathaway, Scott L02 Apr 2002 11:17 
Subject:sql syntax question
From:Hathaway, Scott L (scot@lmco.com)
Date:04/02/2002 11:17:55 AM
List:com.mysql.lists.mysql

I have the following query:

select *, max(event_date) as high, min(event_date) as low from schedule where event_date between '2002-03-01' and '2003-04-30' group by week_ending,meeting_id order by name, event_date, start_time

If I order by event_date, start_time, name, I get the proper results. If I order by as above, the first week_ending group gets broken into two parts (the last part of the group gets placed at the end of the sql results).

Can anyone tell me why?

Thanks, Scott Hathaway