UPDATE ts_StockCustomer
SET CorpID = nmps企业用户.id
from nmps企业用户(这句是关键)
WHERE (CustName = nmps企业用户.企业名称)
把nmps企业用户中含有ts_StockCustomer中含有CustName的id赋给ts_StockCustomer的CorpID
UPDATE ts_StockCustomer
SET CorpID = nmps企业用户.id
from nmps企业用户(这句是关键)
WHERE (CustName = nmps企业用户.企业名称)
把nmps企业用户中含有ts_StockCustomer中含有CustName的id赋给ts_StockCustomer的CorpID