错误：位置或接近"case"的语法错误：226

Question

select 
case when cld.last_milestone='APPROVED' THEN clf.application_received_and_approved_at
case when cld.last_milestone='LOCK' THEN clf.locked_at
case when cld.last_milestone='FUNDING' THEN clf.funded_at
end as Last_Milestone_at
from
core.loan_file_milestone_days as clf

我不明白这里出了什么问题?

Answer 1

正确:

select 
case
when clf.last_milestone='APPROVED' THEN clf.application_received_and_approved_at
when clf.last_milestone='LOCK' THEN clf.locked_at
when clf.last_milestone='FUNDING' THEN clf.funded_at
end as Last_Milestone_at
from
core.loan_file_milestone_days as clf

Answer 2

select clf.loan_file_id,cld.last_milestone,
case cld.last_milestone
when 'APPROVED' THEN clf.application_received_and_approved_at
when 'LOCK' THEN clf.locked_at
when 'FUNDING' THEN clf.funded_at
end as Last_Milestone_at
from
core.loan_files as clf
inner join
core.loan_file_milestone_days as cld
using(loan_file_id)

这是解决了的问题谢谢大家而不是使用cold。Last_milestone在条件中一次又一次地使用案例cld.milestone当条件那么…当条件那么…结束在