title: Mysql query: pull data from two tables, nested query?
body: <p>Given two tables:</p>
  <p>orders table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>order_id</th>
  <th>name</th>
  <th>total</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>001</td>
  <td>Joe</td>
  <td>34.99</td>
  </tr>
  <tr>
  <td>002</td>
  <td>Bob</td>
  <td>97.21</td>
  </tr>
  <tr>
  <td>003</td>
  <td>Bill</td>
  <td>100.32</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>order_products table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>order_product_id</th>
  <th>order_id</th>
  <th>product_id</th>
  <th>name</th>
  <th>quantity</th>
  <th>price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>001</td>
  <td>001</td>
  <td>358</td>
  <td>green dog toy</td>
  <td>1</td>
  <td>9.99</td>
  </tr>
  <tr>
  <td>002</td>
  <td>001</td>
  <td>736</td>
  <td>purple cat toy</td>
  <td>1</td>
  <td>7.34</td>
  </tr>
  <tr>
  <td>003</td>
  <td>001</td>
  <td>921</td>
  <td>blue dog toy</td>
  <td>1</td>
  <td>5.43</td>
  </tr>
  <tr>
  <td>004</td>
  <td>001</td>
  <td>925</td>
  <td>red cat toy</td>
  <td>1</td>
  <td>4.48</td>
  </tr>
  <tr>
  <td>005</td>
  <td>002</td>
  <td>921</td>
  <td>blue dog toy</td>
  <td>1</td>
  <td>5.43</td>
  </tr>
  <tr>
  <td>006</td>
  <td>003</td>
  <td>801</td>
  <td>yellow dog toy</td>
  <td>1</td>
  <td>9.43</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>How do I select all orders and then get all products for that order (orders.order_id=order_products.order_id)?  There can be more than one product per order so I don't think I can left join it.</p>
  <p>Thanks for any advice.</p>