Including count(x) = 0
Posted: Fri Jan 16, 2004 7:51 am
I'm doing a hall of fame list and I have two tables:
Players:
PID-NICK (Playerid,Nick)
1-KANA
2-KOIRA
3-KETTU
And
Games:
GID-WID (Gameid, Winnerid)
1-1
2-1
3-2
What query gives the following result:
NICK-NUMBER OF WINS
KANA-2
KOIRA-1
KETTU-0
I dont know how to get the KETTU included since he has no wins.
Players:
PID-NICK (Playerid,Nick)
1-KANA
2-KOIRA
3-KETTU
And
Games:
GID-WID (Gameid, Winnerid)
1-1
2-1
3-2
What query gives the following result:
NICK-NUMBER OF WINS
KANA-2
KOIRA-1
KETTU-0
I dont know how to get the KETTU included since he has no wins.