Update t_Gd_Warebase set WareQty = (selectsum(B.QtyKY) From t_Gd_Warebase A,T_GD_WareDeta B where A.MateNo = B.MateNo and A.WareType = B.WareType and A.MateNo ='A002'and A.WareType ='ZS' groupby B.MateNo,B.WareType) Where MateNo ='A002'and WareType ='ZS'