Mysql错误: Subquery returns more than 1 row

Question

嗨，我有一个 mysql 查询来获取一些 id(studentID)，如下所示

select t1.studentID 
from remittedfees t1 
where (select t2.fees 
       from feesasigned t2 
       where t2.studentID=t1.studentID) = (select sum(t3.remittedAmt) 
                                           from remittedfees t3 
                                           where t3.studentID = t1.studentID);

但查询返回以下错误

  ERROR 1242 (21000): Subquery returns more than 1 row

如何重写查询以获得结果？

Answer 1

试试这个[更新]:

SELECT t2.studentID 
  from feesasigned t2 
  INNER JOIN (
  SELECT t3.studentID, SUM(t3.remittedAmt) FeeSum
  FROM remittedfees t3 
  GROUP BY t3.studentID) v ON t2.studentID = v.studentID and t2.fees = v.FeeSum