UPDATE b SET b.WMSLogisticId = a. LogID ,b.WMSLogisticWayId=a.ShippingCode FROM #LogisticsShippingMethod a,ShipVia b WHERE a.ShippingCode = b.ForwarderByID
UPDATE b SET b.WMSLogisticId = a. LogID ,b.WMSLogisticWayId=a.ShippingCode FROM #LogisticsShippingMethod a,ShipVia b WHERE a.ShippingCode = b.ForwarderByID
转载于:https://www.cnblogs.com/TzH-Sky/p/5661296.html