我估计是你的 SUM(contract_split_amount) AS ‘money’的问题 MONEY是关键词 需要加引号 你加上试试。
我加了,还是报错 错误是:Unknown column 'cs.money' in 'where clause'
试试这个:SELECT money FROM (SELECT SUM(contract_split_amount) AS money FROM contract_split cs WHERE contract_info_id=65 AND contract_amount_id IN (SELECT id FROM contract_amount_type WHERE id>=4 AND id<=9)) AS t WHERE money>0
报错?
Invalid use of group function
错误是:Unknown column 'cs.money' in 'where clause'
money
FROM
(SELECT
SUM(contract_split_amount) AS money
FROM
contract_split cs
WHERE
contract_info_id=65 AND contract_amount_id IN (SELECT
id
FROM
contract_amount_type
WHERE
id>=4 AND id<=9)) AS t
WHERE
money>0