oracle 单行子查询出现多个行的错误

select  distinct d.name, t.qry_code ,b.info_query_times from qry_log  t left join tdcode b on t.qry_code = b.code_info left join
tdcode_batch c on b.sys_batch = c.sys_batch left join product d on c.product_id = d.id  left join qry_exception_def e on d.id = e.product_id
where b.info_query_times>=e.qry_times


and e.period >= (select ((max(to_date(to_char(a.qry_time,'yyyy-mm-dd hh24-mi-ss'),'yyyy-mm-dd hh24-mi-ss'))-min(to_date(to_char(a.qry_time,'yyyy-mm-dd hh24-mi-ss'),'yyyy-mm-dd hh24-mi-ss'))))*24
from qry_log a group by a.qry_code)


在这里and e.period >= 出现了单行子查询出现多个行的错误，请问谁能帮我改过来

---

and e.period >= all (select ((max(to_date(to_char(a.qry_time,'yyyy-mm-dd hh24-mi-ss'),'yyyy-mm-dd

---

谢谢，不过好像和我要的结果不一样，一条记录没有

---

SQL code:
select distinct d.name, t.qry_code ,b.info_query_times
from qry_log t left join tdcode b on t.qry_code = b.code_info
left join tdcode_batch c on b.sys_batch = c.sys_batch
left join product d on c.product_id = d.id
left join qry_exception_def e on d.id = e.product_id
where b.info_query_times >= e.qry_times
and exists (select 1 from qry_log a
where a.qry_c