mysql子查询返回多行_mysql-带子查询返回“单行子查询返回多行”...

这是我的查询：

SELECT TRANS_MSTR.branch_id

FROM TRANS_MSTR, BRANCH_MSTR

WHERE BRANCH_MSTR.branch_type_desc = 'ATM ONLY'

And ( SELECT SUM(TRANS_MSTR.trans_amount)

FROM TRANS_MSTR

WHERE TRANS_MSTR.trans_yyyymm = '201511'

GROUP BY TRANS_MSTR.branch_id) < 100;

“ORA-01427: single-row subquery returns more than one row”

是我得到的错误.我真的不知道那是什么意思？我的查询总体目标是返回分支ID和总和,总和小于100.

当我尝试像这样修复它时：

SELECT TRANS_MSTR.branch_id,

(SELECT SUM(TRANS_MSTR.trans_amount)

FROM TRANS_MSTR

WHERE TRANS_MSTR.trans_yyyymm = '201511'

GROUP BY TRANS_MSTR.branch_id) as TransAmt

FROM TRANS_MSTR, BRANCH_MSTR

WHERE BRANCH_MSTR.branch_type_desc = 'ATM ONLY'

And TransAmt < 100;

它告诉我TRANSAMT是无效的标识符.但是我以为您可以别名子查询？