title: How to prevent SQL multiple-join-rows error and apply values for multiple rows?
body: <blockquote>
    <p>ERROR [HY000] ERROR:  Update canceled: attempt to update a target row
    with values from multiple join rows</p>
  </blockquote>
  
  <p>Is there a way to avoid this error and update each row that contains E, despite having multiple join rows?</p>
  
  <pre><code>UPDATE V
  SET 
  V.S = M.S,
  V.T = M.T,
  V.U = M.U
  FROM MAP M
  WHERE AND V.E = M.E;
  </code></pre>