-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 At Donnerstag, 4. April 2002 17:57 Hathaway, Scott L wrote: > Yes, that should only cause a reordering within the group itself, but in my > case, the group breaks into two groups!
Your 'group by' clause needs to have the same fields (and in the same order) as your 'order by' clause or this is bound to happen - resp. as soon as the fields are no longer identical (counted from the beginning of the 'order by' and 'group by' clause) duplicate groups are possible. Or I misunderstood you completely .o) In that case please include examples of your query with actual values. Thanks - -- 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 iD8DBQE8rOL372vu22ltWBERAo+CAJ9hzmX+JP12rIcKD/dYnLVWUnC4nwCeKCKY OdQN5qkUrtOTmstXWfsUM34= =uPlX -----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
