title: The target table of the UPDATE is not updatable
body: <p>I need to run this query :   </p>
  
  <pre><code>UPDATE TempRH T 
      JOIN (
             SELECT offices_id,MAX(Poids)AS Poids
             FROM TempRH  
             GROUP BY 
                    offices_id
            )T1
      ON T1.offices_id=T.offices_id
      SET T1.Poids=0
  </code></pre>
  
  <p>but on execution it gives an error:</p>
  
  <pre><code>#1288-The target table T1 of the UPDATE is not updatable.
  </code></pre>
  
  <p>Any solutions?</p>