UPDATE TABLE_A INNER JOIN TABLE_B ON TABLE_A.ID = TABLE_B.ID SET TABLE_A.NAME = TABLE_B.NAME