mysql - 在 syntaq mysql 查询中出现错误“子查询返回超过 1 行”

Question

我发现一个错误：Subquery returns more than 1 row在我的语法查询中：

SELECT  (SELECT username 
         FROM users 
         WHERE id_user = b.id_user) AS kdtk,
        (SELECT masalah 
         FROM kategori_masalah 
         WHERE id_kategori=a.id_kategori) AS masalah,
        (SELECT nama 
         FROM users 
         WHERE id_user = b.id_user) AS nama,
         b.id_dept AS asal,a.tujuan_id_dept AS tujuan,
         (SELECT COUNT(*) 
          FROM (SELECT d.id_kategori,e.id_user,d.id_detail,d.tgl_buat 
                FROM complaint d,detail_complaint e 
                WHERE d.id_kategori LIKE '%%' AND e.id_user LIKE '%%' AND d.id_detail=e.id_detail 
                      AND d.tgl_buat BETWEEN '2019-04-01 00:00:00' AND '2019-06-09 23:59:59') AS jumlah 
           WHERE id_detail=id_detail GROUP BY id_kategori,id_user)
FROM complaint a,detail_complaint b 
WHERE a.id_kategori LIKE '%%' AND b.id_user LIKE '%%' AND a.tujuan_id_dept='EDP' 
      AND a.id_detail=b.id_detail AND a.tgl_buat BETWEEN '2019-04-01 00:00:00' AND '2019-06-09 23:59:59' 
GROUP BY a.id_kategori,b.id_user 
ORDER BY kdtk;

标签： mysql