关联查询并更新数据

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