My current query is really complicated, so I'll only deal with my simplified output here. I'm doing Half-Life stats program, and right now I'm adding in awards to it. This is a snip from my current output: +---------+----------+------------+ | awardId | playerId | awardcount | +---------+----------+------------+ | 7 | 4 | 1 | | 8 | 1 | 2 | | 8 | 44 | 2 | | 9 | 2 | 5 | | 9 | 4 | 5 | | 9 | 5 | 2 | | 9 | 25 | 2 | | 9 | 1 | 1 | | 10 | 4 | 7 | | 10 | 5 | 3 | | 11 | 4 | 6 | | 11 | 1 | 2 | | 11 | 5 | 1 | | 11 | 36 | 1 | | 11 | 38 | 1 | +---------+----------+------------+ This is what I've been able to get my query down to, for every award it finds who was the top for them. Now what I want is only the top 1 person from each awardID. I tried doing a group by just awardID, but then all the players are put together as one. How can I have awardID and playerID seperate but only 1 awardID? Thanks for any help, -Rufus [EMAIL PROTECTED] ICQ: 26037212 http://www.LionGames.com --------------------------------------------------------------------- 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
