title: SQL Joins with one to many relationship - Combine the many into one row?
body: <p>I have a product table and a price table where a product can have several price rows. Is it possible to do a JOIN statement that returns one row per product with the price column from each price row where product is equal to the product ID? </p>
  
  <p>Right now I have this:</p>
  
  <pre><code>SELECT PT.*, PR.* 
  FROM `products` AS PT 
  RIGHT JOIN `prices` PR 
      ON PR.`product` = PT.`ID`
  </code></pre>
  
  <p>And if there are 4 price rows for one product, I get 4 rows in response.</p>