UPDATE `data`, point_de_mesure, data as data2
SET data.`conso`=null 
WHERE 
data.id_point_de_mesure=point_de_mesure.id_point_de_mesure
data2.id_point_de_mesure=data.id_point_de_mesure
AND data2.deduit=1