> SQL STATEMENT:
>
> SELECT
> players.playerid,name,
> count(goals.goalid) AS goals,
> count(penalties.penaltyid) AS penalties
> FROM players
> LEFT JOIN goals ON (players.playerid=goals.playerid)
> LEFT JOIN penalties ON (players.playerid=penalties.playerid)
> GROUP BY players.playerid;
Have you tried:
SELECT
players.playerid,name,
count(DISTINCT goals.goalid) AS goals,
count(DISTINCT penalties.penaltyid) AS penalties
FROM players
LEFT JOIN goals ON (players.playerid=goals.playerid)
LEFT JOIN penalties ON (players.playerid=penalties.playerid)
GROUP BY players.playerid;
?
---------------------------------------------------------------------
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