以下sql:
select
ivt.VIN as CARNO,
fnc.LOAN_BAT_NUM as SCFTXNO,
stg.STG_CODE as OUTHWCODE,
ioc.FNC_EXP_DT as FNCEXPDT
from
COFP.T_CC_AGRM_INF agrm
left join COFP.T_CC_IVT_INF ivt on
agrm.SBDT_AGRM_ID = ivt.SBDT_AGRM_ID
left join COFP.T_CC_STG_INF stg on
ivt.STG_CODE = stg.STG_CODE
left join COFP.T_CC_PLG_FNC_REL fnc on
ivt.VIN = fnc.VIN
and fnc.REL_IS_EFF = '1'
left join T_CC_INSTK_APLY_DTL idl on
ivt.VIN = idl.VIN,
COFP.T_CC_REG_AGRM reg
left join COFP.T_CC_REG_AGRM_REL rel on
reg.REG_AGRM_ID = rel.REG_AGRM_ID
left join COFP.T_IOU ioc on
ioc.FNC_ID = fnc.FNC_ID
where
agrm.SBDT_AGRM_ID = ivt.SBDT_AGRM_ID
and agrm.SBDT_AGRM_ID = rel.SBDT_AGRM_ID
and agrm.AGRM_CTR_STAT = 0
and reg.AGRM_STAT = 1
and ivt.VHCL_PRC_CFRM_STAT = 1
and idl.VHCL_STAT = '1'
and reg.REG_ENTP_ID = '#{REG_ID}'
and agrm.SBDT_AGRM_ID = '#{AGTID}'
在mysql8数据库中执行后报错:Unknown column 'fnc.FNC_ID' in 'on clause',请问什么原因呢?需要怎么修改sql呢?