mysql - 我有错误 1242 子查询返回超过 1 行

Question

select (select Nombre 
        from Pacientes 
        where idPacientes= any(select idPaciente 
                                from Citas 
                                where Dias_idDia= any(select idDia 
                                                      from Dias 
                                                      where fecha = '2013-10-15'))) as 'Nombre',horaInicio, horaTermino,actividad,observacion,recordar,ciudad,tipoCita 
from Citas 
where Dias_idDia = any (select idDia 
                        from Dias 
                        where fecha='2013-10-15')
order by horaInicio;

我有错误 1242，如果有人可以帮助解决这个问题，因为它给我的系统带来了很多麻烦。型

Answer 1

子查询的行数不正确:

错误 1242(ER_SUBSELECT_NO_1_ROW)SQLSTATE = 21000Message = "子查询返回多于 1 行"对于子查询必须最多返回一行但返回多行的语句，会发生此错误。考虑以下示例:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

如果 SELECT column1 FROM t2 只返回一行，则前面的查询将起作用。如果子查询返回多行，将出现错误 1242。在这种情况下，查询应重写为:

SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2);

Reference