Re: Max count from 2 groups

2001-07-05 Thread Rufus
FROM hlstats_Events_Frags, hlstats_Awards WHERE hlstats_Events_Frags.weapon = hlstats_Awards.code GROUP BY hlstats_Awards.awardId, hlstats_Events_Frags.killerId ORDER BY hlstats_Awards.awardId, awardcount DESC Hope this clears it up a bit, -Rufus [EMAIL PROTECTED] ICQ: 260

Max count from 2 groups

2001-07-05 Thread Rufus
wardID 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) ht