thanks

You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'snx_comuni
inner join snx_province on snx_comuni.provincia_id = snx_province.pr' at
line 1

with

update snx_comuni set sta_id = 2782 snx_comuni
inner join snx_province on snx_comuni.provincia_id =
snx_province.provincia_id
inner join snx_regioni on snx_province.regione_id = snx_regioni.regione_id
where snx_regioni.codice_regione = 'PIE'