title: How can I get a join to fill in missing values?
body: <p>Given the following table:</p>
  
  <pre><code>name             date           val1         val2       val3
  --------------------------------------------------------------
  A                11/20/2013      34           12         123
  B                11/20/2013      657          3465       568 
  A                11/21/2013      12           67         458
  B                11/21/2013      524          45         3654  
  C                11/21/2013      56           25         55432
  </code></pre>
  
  <p>How can I get results like this?</p>
  
  <pre><code>A                11/20/2013      34           12         123
  B                11/20/2013      657          3465       568
  C                11/20/2013      0            0          0 
  A                11/21/2013      12           67         458
  B                11/21/2013      524          45         3654 
  C                11/21/2013      56           25         55432
  </code></pre>
  
  <p>I'm pretty sure this can be done but just can't figure it out.</p>