title: Update column based on select from another table
body: <p>Im traying to update a table based on a slect from another table. Both tables have in common the name coll.</p>
  
  <p>so the idea is grom hitorial to get the min price of each name, and update those to every row in names that mactch the name.</p>
  
  <p>I have tried several examples found here, but none did the trick.</p>
  
  <p>This is the inner select</p>
  
  <pre><code>SELECT name, MIN(price) FROMhistorial group by name
  </code></pre>
  
  <p>this should update a </p>
  
  <pre><code>UPDATE names set MIN_PRICE = min_price_from_select WHERE name = name_from_select
  </code></pre>
  
  <p>result should be, the table Names updated with the min prices from historial.</p>