关联查询并更新数据

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