select * From V_XT_XTGNDY start with GNDYXH
IN
(
select GNDYXH From V_XT_XTGNDY WHERE XTMKXH='201'
AND GNDYXH IN (SELECT GNDYXH FROM XT_YHFZQX WHERE YHFZBH IN (SELECT YHFZBH FROM XT_YHFZCY WHERE YHRYDM='DBA'))
)
connect by prior FLDYXH=GNDYXH
IN
(
select GNDYXH From V_XT_XTGNDY WHERE XTMKXH='201'
AND GNDYXH IN (SELECT GNDYXH FROM XT_YHFZQX WHERE YHFZBH IN (SELECT YHFZBH FROM XT_YHFZCY WHERE YHRYDM='DBA'))
)
connect by prior FLDYXH=GNDYXH
