看看我的语句,我是在access中的 select commodityid ,commodityname, sum(amount) from sells where commodityid in(select distinct commodityid from sells) order by commodityid 它提示,commodityid不是合计函数的一部分 我改成以下语句后,汇总出的结果又是各个商品的总和select commodityid ,commodityname,(select sum(amount) as mamount from sells where commodityid=commodityid ) as newAmount from sells where commodityid in(select distinct commodityid from sells) order by commodityid
... set rs = cn.execute("select [商品名],sum([商品数]) as [总数] from sells group by [商品名] ") ...
select commodityid ,commodityname, sum(amount) from sells where commodityid in(select distinct commodityid from sells) order by commodityid
它提示,commodityid不是合计函数的一部分
我改成以下语句后,汇总出的结果又是各个商品的总和select commodityid ,commodityname,(select sum(amount) as mamount from sells where commodityid=commodityid ) as newAmount from sells where commodityid in(select distinct commodityid from sells) order by commodityid
set rs = cn.execute("select [商品名],sum([商品数]) as [总数] from sells group by [商品名] ")
...