select goodsid,goodsname,goodsxinhao,cankaojinjia,cankaoshoujia,goodsclassname,goodsunitname,
sum(shuliang)
from dbo.Goods as a,dbo.Goodsclass as b,dbo.Goodsunit as c ,dbo.GoodsStock as d
where a.idgoodsclass=b.goodsclassid and a.idgoodsunit=c.goodsunitid and a.goodsid=d.idgoods
group by goodsid,goodsname,goodsxinhao,cankaojinjia,cankaoshoujia,goodsclassname,goodsunitname
sum(shuliang)
from dbo.Goods as a,dbo.Goodsclass as b,dbo.Goodsunit as c ,dbo.GoodsStock as d
where a.idgoodsclass=b.goodsclassid and a.idgoodsunit=c.goodsunitid and a.goodsid=d.idgoods
group by goodsid,goodsname,goodsxinhao,cankaojinjia,cankaoshoujia,goodsclassname,goodsunitname
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货