[snip] Thanks so much. There was a slight syntax change, replacing your first ORDER BY with a GROUP BY, but it worked. [/snip]
Yep *slapping forehead* I saw that I had one too many ORDER BY's there and forgot to send an update. :) Glad it helped! Jay mysql, sql, query "It's hip to snip!" --------------------------------------------------------------------- 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
