UPDATE userfield INNER JOIN userfield2 on userfield.userid = userfield2.userid SET userfield.field15 = userfield2.field15;