mysql - SQL UPDATE on a JOIN of two tables n:n -

i need update query on result of 2 table join. these 2 tables in n:n relationship. here's tables:

table 1:

*cities*   [this table name]  idcities (primary key) cityname 

relationship tab:

*user_has_cities*   [this table name]  user_iduser (foreign key)  cities_idcities (foreign key) 

table 2:

*user*    [this table name]  iduser (primary key)  username  password  name  surname  

for example, need update "cityname" (setting los angeles) user.iduser = 1 , cities.idcities = 2;

how can this?

in ms sql:

update c set c.cityname = 'los angeles' cities c inner join user_has_cities u on u.ities_idcities = c.idcities c.idcities = 2 , u.iduser = 1 

in mysql:

update cities c inner join user_has_cities u on u.ities_idcities = c.idcities , c.idcities = 2 , u.iduser = 1 set c.cityname = 'los angeles'