无法在一个查询中的多个查询上使用聚合函数


unable to use aggregate function on multiple queries in one query

这是我的查询…我不能一次在多个表上使用聚合函数-计数。

$qu="SELECT distinct calls.c_number, count(type) as count1,SUM(charges * duration) as total,sum(duration) as duration1,billing_details.payment as pay,packages.(count)activation as act
 FROM calls
  INNER 
    JOIN packages
    ON calls.c_number=packages.c_number 
 WHERE
 calls.date>= DATE_FORMAT( $date, '%Y/%m/01' ) AND

calls.date< DATE_FORMAT( $date + INTERVAL 1 MONTH, '%Y/%m/01') group by c_number desc having SUM(charges * duration) > 0  "; 

它给了我这个错误:

FUNCTION packages.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

这与PHP没有任何关系…

这与你的顶行有关-

$qu="SELECT distinct calls.c_number, count(type) as count1,SUM(charges * duration) as total,sum(duration) as duration1,billing_details.payment as pay,packages.(count)activation as act

你希望"packages.(count)activation"做什么?你是说count(packages.activation)吗?

try this

count(packages.activation)

而不是

 packages.(count)activation