查询时候，有三个count针对一个count带查询条件

Question

SELECT SUM(P.IN_CARD_VALUE-P.OUT_CARD_VALUE) AS DISH_TOTAL_SALES_MONEY , SUM(P.WEIGHT) AS DISH_TOTAL_SALES_WEIGHT, COUNT(DISTINCT P.SALARY_NO) AS RECEPTION_NUMBER FROM T_PM_PAY P
LEFT JOIN T_DM_DISH D
ON P.DISH_NO = D.DISH_NO
过滤只针对 COUNT(DISTINCT P.SALARY_NO) 起作用该怎么写？

Answer 1

把count的结果当做表来用。select sum,sum, count from p left join d on ..... left join counttbl on....