Can i use update with inner join?

[Adagedgeplill]

i want to use update for *any record and all record * of my table that column1 <> column2my command is : update table1 set name = (select name from table2 where code1<>code2 and table1.id=table2.id)is it possible?and is it possible to use inner join in update command?