title: Join tables with Aggregate value
body: <p>I've two tables, named Table-A and Table-B. Please refer given tables . I want to join these after taking the aggregate of 'Value' column in both tables. For eg;</p>
  
  <p><strong>TABLE-A</strong></p>
  
  <pre><code>     Name    Value1
        ABC     10
        ABC     18
        ABC     12
        DEF     5
        XYZ     15
        XYZ     16
  </code></pre>
  
  <p><strong>TABLE-B</strong></p>
  
  <pre><code>     Name    Value2
        ABC     15
        ABC     5
        XYZ     9
  </code></pre>
  
  <p>My expected result is,</p>
  
  <p><strong>Result</strong></p>
  
  <pre><code>     Name    Value1   Value2
        ABC      40       20
        DEF      5        0
        XYZ      31       9
  </code></pre>
  
  <p>Hope you understand my question. Any help will be appreciated.</p>