title: Finding a Table's Contents in Another Table using BigQuery
body: <p>I have two tables, table A and table B:</p>
  
  <p>A has data stored in this way:</p>
  
  <pre><code>word1
  word4
  word2
  word3
  </code></pre>
  
  <p>B has data stored in this way:</p>
  
  <pre><code>  word1            value1
    word1            value2
    word2            value3 
    word2            value4
    word2            value5 
    word3            value6
    word3            value7
  </code></pre>
  
  <p>what is the query I can use in google BigQuery to generate a table such as</p>
  
  <pre><code>word1    value1+value2
  word2    value3+value4+value5
  word3    value6+value7
  </code></pre>
  
  <p>where word1, word2, etc are Strings, and value1, value2, etc are integers?</p>