目的:根据物料PN对应采购Buyer的表sfu_purchase_items更新表mra_records中物料Item对应的Buyer信息。
方法1:SQL语句:
update `buyer`.`mra_records` set `BuyerNo` = (select BuyerCode from `
目的:根据物料PN对应采购Buyer的表sfu_purchase_items更新表mra_records中物料Item对应的Buyer信息。
方法1:SQL语句:
update `buyer`.`mra_records` set `BuyerNo` = (select BuyerCode from `