数据表 品名 规格 入库数量
11 22 20
11 22 40
如果有符合条件的入库数量累加,没有的显示为0SELECT pm AS 品名,gg as 规格, iif(sum(cksl) is null ,0,1) AS 入库总量 FROM ck where (pm = '11') and (gg = '22')上面的语句错误!请问正确的应该如何写?
11 22 20
11 22 40
如果有符合条件的入库数量累加,没有的显示为0SELECT pm AS 品名,gg as 规格, iif(sum(cksl) is null ,0,1) AS 入库总量 FROM ck where (pm = '11') and (gg = '22')上面的语句错误!请问正确的应该如何写?
where (pm = '11 ') and (gg = '22 ') group by pm,gg