ORA-01427: 单行子查询返回多于一个行，请问怎么改？

ORA-01427: 单行子查询返回多于一个行，请问怎么改？
select a.next_point,t.c_name,a.item_id,a.s_num,(select o.name from org o where o.orgid=a.to_org) as to_org,a.from_user,(select o.name from org o where o.orgid=a.from_org) as form_org, a.to_user,(select substr(a.submit_date,0,10) from item_procedure) as submit_date,t.base_id,t.c_name,t.createdate,t.room ,t.item_price,remarks,t.state
from item_procedure a,app_cmb_item t
where a.item_id = t.item_id and a.next_point = '5' and 1=1 and 2=2 and 3=3 and 4=4

表示楼主这个SQL 粘贴的太乱，根本看不下去，而且还是各种子查询的嵌套，问题已经很清楚了，把每个子查询单独执行以下就知道那里错了

改一下 update mis_base.fcltproperty set value = '1', text = '合' where facilityid in (select rid from mis_base.asset where gid = 212318) and nameen= 'kgzt' =只能等于一个值，用in的话就能等于多个值了， select rid from mis_base.asset where gid = 212318查询结果肯定大于一条，所以数据库无法识别出来，改成in就没问题了