cookieY
[Question] 使用临时表提示不存在
描述问题 清晰而简洁地描述你遇到的问题
复现
重现该行为的步骤:
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'表中不存在
截图
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Title: [Question] Using temporary table prompt does not exist
