根据条件关联匹配更新相应的字段值为另外一个表的字段值
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.snameUPDATE m SET m.sLi
根据条件关联匹配更新相应的字段值为另外一个表的字段值
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.snameUPDATE m SET m.sLi