UPDATE a SET a.Name = b.Describe --收件地编码 FROM WMS_Material a JOIN ErpMater b ON b.MaterialNo = a.Code