如何把三个查询简化为一个查询？

Kil1

源表JKX，如下图：


要求取得结果如图：



查询A：SELECT JKX.门店, Count(JKX.状态) AS 状态之计数 FROM JKX GROUP BY JKX.门店;
查询B：SELECT JKX.门店, Count(JKX.状态) AS 状态之计数 FROM JKX WHERE (((JKX.状态)>0)) GROUP BY JKX.门店;
查询C：SELECT 查询A.门店, 查询B.状态之计数 AS 正, 查询A.状态之计数 AS 总, [正]/[总] AS 正比总
            FROM 查询A INNER JOIN 查询B ON 查询A.门店 = 查询B.门店;

查询C是通过两个中间查询才取到所要结果，请教如何以一个查询直接获取结果？谢谢！

ly

1. SELECT JKX.门店, Sum(IIf([状态]>0,1,0)) AS 正, Count(JKX.状态) AS 总, [正]/[总] AS 正比总
   
2. FROM JKX
   
3. GROUP BY JKX.门店

复制代码

Kil1

ly 发表于 2020-10-16 15:19

好！感谢！