[Question] 使用临时表提示不存在

[zhenglin305]

描述问题 清晰而简洁地描述你遇到的问题

复现 重现该行为的步骤: sql如下： update crm.crm_company_service_intentions ccsi join ( select * from financedb.finance_product_company_relate where status = 2 group by company_id HAVING count() > 1 ) fpcr on fpcr.company_id = ccsi.company_id left join ( select ofunds. from orderdb.order_funds ofunds join orderdb.orders o on o.id = ofunds.order_id where o.status in (7,8,9,10,11,15) order by ofunds.created_at desc limit 1 ) ofunds on ofunds.company_id = ccsi.company_id set ccsi.account_period_type = 3, ccsi.finance_product_id = IFNULL(ofunds.finance_product_id, fpcr.finance_product_id), ccsi.finance_days = IFNULL(ofunds.loan_limit, 60);

检测不通过：列'ofunds.loan_limit'表中不存在

截图