update t2 set t2.FDecimal3=isnull(t3.FQty,0) from t_BOS t1 inner join t_BOS2 2 on t1.FID=t2.FID left join (select FItemID,sum(isnull(FQty,0)) [Fqty] from ic group by FItemID) t3 on t3.FItemID=t2.FBase where t1.Fbillno=sFbillNO 这句语句是什么意思?“[Fqty]” 是什么意思啊,请高手解答!!
谢谢你啊!
就是select FItemID,sum(isnull(FQty,0)) as Fqty from ic group by FItemID 这个语句不太懂,sum(isnull(FQty,0))是什么意思啊,sum(isnull(FQty,0)) as Fqty 是什么意思啊!嘿嘿,我新学的,不太懂