关联查询并更新数据 

UPDATE  b   SET   b.WMSLogisticId    = a. LogID ,b.WMSLogisticWayId=a.ShippingCode
 FROM #LogisticsShippingMethod a,ShipVia b    WHERE a.ShippingCode = b.ForwarderByID

 

posted @ 2016-07-11 18:34  命若天地，就逆天而行  阅读(133)  评论(0)  编辑  收藏  举报