title: SQL: Merging results from two tables into one result
body: <p>I've begun to dive into joins/apply/unions, etc and there's one concept I don't think I understand in this, and I was hoping I could be helped out. Let's say I have two tables, tabone and tabtwo.</p>
  <p>In tabone:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>product</th>
  <th>color</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Eggs</td>
  <td>Tan</td>
  </tr>
  <tr>
  <td>Milk</td>
  <td>White</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In tabtwo:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>product</th>
  <th>price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Eggs</td>
  <td>1.50</td>
  </tr>
  <tr>
  <td>Milk</td>
  <td>2.00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'd like to learn how to write query which will in a single result show me the product, color, and price for any given product.</p>
  <p>Example output I'd like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>product</th>
  <th>price</th>
  <th>color</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Eggs</td>
  <td>1.50</td>
  <td>Tan</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>From what I've gathered so far, I don't see quite how a join or union can achieve this in one result. All of my testing gives me multiple columns with the color for example not merging. I'd appreciate some help on this!</p>