Error trying to SET a field when two fields in different tables match
UPDATE ykz2d_maps_integration , ykz2d_crmery_deals
SET catid = '584' 
where ykz2d_crmery_deals.company_id = ykz2d_maps_integration.company_id
;


The table must be listed in the update clause to avoi the error message