Show count value 0 when row doesn't exist MYSQL
<p>I have 2 tables Game and Bet. I want to count the number of bets for each game. However my current query doesn't include a game when there is no bet for that specific game id.</p>

<p>here is my current query:</p>

<pre><code>SELECT g.*, 
       Count(*) AS participants 
FROM   game g, 
       bet b 
WHERE  b.game_id = g.id 
       AND USER = ? 
GROUP  BY g.id 
</code></pre>

<p>So to make it more clear lets say I have 3 rows in my Game table. There are 4 bets for game1 , 2 bets for game2 and there is no row associated with game3 in Bet table. The result should be:</p>

<pre><code>g1  4
g2  2
g3  0
</code></pre>

<p>I'd appreciated any help.              </p>