根据条件关联匹配更新相应的字段值为另外一个表的字段值
UPDATE m SET m.sLinkMan = t.PK_ID from FX_ST_T_MoneySellOrder m inner join CRM_Cust_T_Linkman t on m.slinkman=t.sname
UPDATE m SET m.sLinkManId= t.PK_ID from FX_ST_T_OutStore m inner join CRM_Cust_T_Linkman t on m.sRecvMan=t.sname