带选择的MYSQL更新

I want to update a value form another table value this is the my code

UPDATE 
ag_personal_information 
SET
ag_personal_information.ag_zone_id = 
  (SELECT ag_officer_service_information.ag_zone_id 
                  FROM ag_officer_service_information) 
WHERE
ag_officer_service_information.ag_zone_id <> ag_personal_information.ag_zone_id

try this

UPDATE ag_personal_information AS A 
SET ag_personal_information.ag_zone_id = (
            SELECT ag_officer_service_information.ag_zone_id 
            FROM ag_officer_service_information AS B 
            WHERE A.ag_officer_service_information.ag_zone_id <> B.ag_personal_information.ag_zone_id) 

Put = in between ag_officer_service_information.ag_zone_id and ag_personal_information.ag_zone_id

 UPDATE ag_personal_information 
     SET ag_personal_information.ag_zone_id =
    (SELECT ag_officer_service_information.ag_zone_id FROM ag_officer_service_information) 
     WHERE ag_officer_service_information.ag_zone_id = ag_personal_information.ag_zone_id