Yes, that should only cause a reordering within the group itself, but in my case, the group breaks into two groups!
Scott -----Original Message----- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:58 AM To: Hathaway, Scott L; Mysql (E-mail) Subject: Re: help with query, pelase -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote: > 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). Probably the last group has different 'order by' values.(?) - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632 hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8rGoN72vu22ltWBERAmjUAJ0bEv1CYkH+QhuDaUZAK7eRfX+TqwCePM5A VwFM2H5hSez7lwiFqP7GK1I= =0X4M -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php