title: MySql group by and include null
body: <p>I have these 2 tables:</p>
  
  <pre><code>Table members
  | id | name    |
  ----------------
  | 01 | John    |
  | 02 | Michael |
  | 03 | Richard |
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Table payments
  | id  | eur  | name    | date       |
  -------------------------------------
  | 238 | 9.95 | John    | 1323377751 |
  | 233 | 9.95 | Michael | 1397864609 |
  | 220 | 9.95 | Michael | 1397852739 |
  | 215 | 9.95 | John    | 1397852719 |
  |   2 | 9.95 | Richard | 1323377751 | // This payment was made more than 24h ago
  </code></pre>
  
  <p>Bellow is my query:</p>
  
  <pre><code>select id, m.name, sum(eur) as total 
  from mambers as m
  left join payments as p
  on m.name = p.name
  where p.date &gt;= unix_timestamp(current_timestamp - interval 24 hour)
  group by m.name
  </code></pre>
  
  <p>and the return is:</p>
  
  <pre><code>| John    | 19.90 |
  | Michael | 19.90 |  
  </code></pre>
  
  <p>but i need to include also the members with no payments in last 24 like this:</p>
  
  <pre><code>| John    | 19.90 |
  | Michael | 19.90 |
  | Richard | 00.00 |
  </code></pre>