title: Sort product data from multiple tables in MySQL
body: <p>I have two tables. The first:</p>
  
  <pre><code>Products table:
  
  +----+-----------+
  | id | name      | 
  +----+-----------+
  |  1 | Product 1 |
  |  2 | Product 2 |
  |  3 | Product 3 |
  +----+-----------+
  </code></pre>
  
  <p>This contains product names and other table contains prices for different product variants:</p>
  
  <pre><code>Products prices table:
  
  +-----+------------+-------------+
  | id  | product_id | price       |
  +-----+------------+-------------+
  |  5  | 1          |  12.00      | 
  |  6  | 1          |  32.00      | 
  |  11 | 1          |  56.00      | 
  |  14 | 2          |  11         | 
  |  44 | 3          |  12         |
  +-----+------------+-------------+
  </code></pre>
  
  <p>I need to create a sort on price (lowest and highest)</p>