The target table of the UPDATE is not updatable

Question

I need to run this query :

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

but on execution it gives an error:

#1288-The target table T1 of the UPDATE is not updatable.

Any solutions?

Answer 1

Seems to me a small change would fix this?

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 T.Poids=0 

Change T1.Poids to T.Poids. So you SET a value on the TABLE you want to UPDATE