查询数据库时报错ORA-00913: too many values
从数据库里获取数据时需要多表联合查询,不仅要 t表里的所有属性,也需要pe表里的一些属性,所以我尝试了下面的代码:
select t.*,
(select pe.exam_score, pe.total_num, pe.error_num, pe.errata from t_plan_exam pe where pe.task_code = t.task_code)
from t_plan_simu t
where t.dele_this = '0'
and t.task_code = 0012012
但是报错ORA-00913: too many values,
在附加查pe表的一些属性时,把其分开一个个来查,如下代码,报错解决。
select t.*,
(select pe.exam_score from t_plan_exam pe where pe.task_code = t.task_code),
(select pe.total_num from t_plan_exam pe where pe.task_code = t.task_code),
(select pe.error_num from t_plan_exam pe where pe.task_code = t.task_code),
(select pe.errata from t_plan_exam pe where pe.task_code = t.task_code)
from t_plan_simu t
where t.dele_this = '0'
and t.task_code = 0012012
这样代码就多写了好多,不知道各位大佬有没有更好的解决方法。