如题,sql如下select
*
from base_dep_lab bdl
inner join v_report_sj6_render sj6 on trim(sj6.base_dep_code)
in(
select code from base_dep start with code = bdl.base_dep_code connect by prior code = base_dep_code_parent
)
inner join base_dep bd on bdl.base_dep_code = bd.code
where
sj6.year = (select value from system_config where code = 'report_year')
and bdl.reported = 1 and sj6.status=1
*
from base_dep_lab bdl
inner join v_report_sj6_render sj6 on trim(sj6.base_dep_code)
in(
select code from base_dep start with code = bdl.base_dep_code connect by prior code = base_dep_code_parent
)
inner join base_dep bd on bdl.base_dep_code = bd.code
where
sj6.year = (select value from system_config where code = 'report_year')
and bdl.reported = 1 and sj6.status=1
select code from base_dep start with code = bdl.base_dep_code connect by prior code = base_dep_code_parent这句中的 bdl.base_dep_code 用到了外面的bdl,所有不能识别。我有什么办法能够实现相同功能呢!