SELECT
`loanac`.`id`,
`loanac`.`name`,
`loanac`.`lacc`,
SUM(`loantrans`.`in`) as totalin,
SUM(`loantrans`.`out`) as totalout
FROM loanac, loantrans
WHERE `loanac`.`lacc`=`loantrans`.`account`
GROUP BY `loanac`.`lacc`
这是我上面的查询，可以很好地显示所有帐户，但是我需要找到SUM（out）> SUM（in）而不是所有帐户的帐户
我尝试使用AND添加条件，但显示错误，有人可以帮忙吗？
在聚合函数（例如SUM或COUNT）上执行标准的方法是在哪里，而不是在哪里
SELECT loanac.id, loanac.name, loanac.lacc, loanac.phone,
SUM(loantrans.in) as totalin, SUM(loantrans.out) as totalout
FROM loanac,
loantrans
WHERE loanac.lacc=loantrans.account
GROUP BY loanac.lacc
HAVING SUM(loantrans.out) > SUM(loantrans.in)
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句