这是我的查询…我不能一次在多个表上使用聚合函数-计数。
$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