MySQL Update Example with INNER JOIN
UPDATE content_type_geshinode AS g INNER join zztemp AS z ON z.nid = g.nid SET g.field_object_type_value = z.field_object_type_value
UPDATE content_type_geshinode AS g INNER join zztemp AS z ON z.nid = g.nid SET g.field_object_type_value = z.field_object_type_value