title: Join tables and append columns
body: <p>I need to join two tables, and append columns where certain data matches. The two tables are setup like so:</p>
  
  <pre><code>Apple         | Flavor
  Fuji          | 1
  Red Delicious | 2
  
  Flavor | Quality  
  1      | Sour  
  1      | Sweet
  2      | Bitter
  2      | Sweet
  </code></pre>
  
  <p>And I need to append a column for each matching flavor quality like so:</p>
  
  <pre><code>Apple         | Quality 1 | Quality 2 
  Fuji          | sour      | sweet
  Red Delicious | bitter    | sweet
  </code></pre>
  
  <p>Notice I also need append an auto-integer to each column header appended.</p>
  
  <p>This seems like a tall task and I'm not sure where to start? Is this even possible? Thanks for the help in advance.</p>