为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.1
【操作系统】：win10
【CPU】:Intel
【问题描述】*：start with (c.kmbh like '%100102%') connect by prior c.kmbh=c.sjfl语句中查询列关联子查询时会报错，可以保证(select d.mc from gx_sys_dmb d where d.zl='kmsx' and d.dm=c.kmsx and d.saasdm='49557147X')as kmsxmc中只有一个确定的值，因为单独查是可以查出来的

详细sql:
select distinct to_char(c.kmnd, 'yyyy') as kmnd,
c.KJZD,
c.sfkjzd,
c.sfmj,
c.sjfl,
c.jb,
c.okjkm,
c.bz,
c.guid,
c.kmbh,
c.kmmc,
c.kmsx,
c.kjnd as year,
'(' || c1.kmbh || ')' || c1.kmmc as sjmc,
(select d.mc
from gx_sys_dmb d
where d.zl = 'kmsx'
and d.dm = c.kmsx
and d.saasdm = '49557147X') as kmsxmc,
c.zjf,
c.yefx,
(case c.yefx
when '1' then
'贷方'
else
'借方'
end) as yefxmc,
c.hslb,
(select d.mc
from gx_sys_dmb d
where d.zl = 'hslb'
and d.dm = c.hslb
and d.saasdm = '49557147X') as hslbmc,
c.kmjc,
c.qyf,

c.czr,
c.czrq,
C.SSZT
from Cw_kjkmszb c
left join Cw_kjkmszb c1
on c1.kmbh = c.sjfl
and c1.kjnd = c.kjnd
and c1.saasdm = c.saasdm
and c1.sszt = c.sszt
where 1 = 1
and nvl(c.sjfl, '0') != 'root'
and c.sszt = 'B9BA12A24DBE4EA89763AFDE76B8C61A'
AND c.SAASDM = '49557147X'
and c.kjzd = '0002'
and c.kjnd = '2024'
start with (c.kmbh like '%1001%')
connect by prior c.kmbh = c.sjfl