title: MYSQL Join two tables and combine row values
body: <p>I have a MySQL database with two tables:</p>
  <p>Table 1:</p>
  <pre><code>    Product_ID | Product_Name | Product_Description
      ------------------------------------------------
      1          | Coca-Cola    | Coke description.
      2          | Pepsi        | Pepsi description.
      3          | Fanta        | Fanta description
      ...
  </code></pre>
  <p>Table 2:</p>
  <pre><code>    Product_ID | Product_SKU | Product_Size | Product_Price
      ------------------------------------------------
      1          | COKE330     | 330ml        | 0.79
      1          | COKE500     | 500ml        | 1.29
      2          | PEPS330     | 330ml        | 0.59
      2          | PEPS500     | 500ml        | 0.99
      ...
  </code></pre>
  <p>I want to query the database and join these two tables together but merge duplicate rows with the same product id so the returned result ends up looking like:</p>
  <pre><code>    Product_ID | Product_Name | Product_Sizes | Product_Prices | Product_Description
      ---------------------------------------------------------------------------------
      1          | Coca-Cola    | 330ml, 500ml  | 0.79, 1.29     | Coke description.
      2          | Pepsi        | 330ml, 500ml  | 0.59, 0.99     | Pepsi description.
      ...
  </code></pre>
  <p>Thank you in advance</p>