update dbo.Inventory
set dbo.Inventory.iInvSPrice=dbo.arrowa.cost,dbo.iInvSCost.iInvLSCost=dbo.arrowa.cost
FROM dbo.Inventory RIGHT OUTER JOIN dbo.arrowa
ON dbo.Inventory.cInvCode = dbo.arrowa.code
set dbo.Inventory.iInvSPrice=dbo.arrowa.cost,dbo.iInvSCost.iInvLSCost=dbo.arrowa.cost
FROM dbo.Inventory RIGHT OUTER JOIN dbo.arrowa
ON dbo.Inventory.cInvCode = dbo.arrowa.code
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货