-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote:
The results you wanted and the results you get were not very clear. Some examples would have gone a long way. >SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates > WHERE (grants.agency = "NIH-O" AND grants.grantid = dates.grantid) > GROUP BY grants.grantid > ORDER BY dates.yearday; > The results are sorted within the groups by yearday. However, the groups themselves are not in any particular order. Try this: order by grants.grantid,dates.yearday; - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1RI7sxxMki0foKoRAlQbAJ92tXMjfXUVLwct/cHG7dtvwkUpUwCg5Um/ VBH0ZcarjD+r805mEd/wg7g= =0SHm -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]