Issues-translate-bot
commented
6 months ago Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Title: [Question] Using temporary table prompt does not exist
描述问题 清晰而简洁地描述你遇到的问题
复现 重现该行为的步骤: sql如下： update
crm.crm_company_service_intentionsccsi join ( select from financedb.finance_product_company_relatewhere 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'表中不存在
截图