SELECT t.account_id FROM mis.hj_approval_survey h INNER JOIN mis.pr_approval_time t ON h.country = t.countryAND t.scheduled_at = SELECT MAX(scheduled_at) FROM mis.pr_approval_time
WHERE country = h.countrySELECT t.account_id FROM mis.hj_approval_survey
我有一个顶点应用程序,它由不同的步骤组成,每个步骤都有一个表(表项目,表send_for_approval,表批准,表start_project,...我想创建一个函数来返回我所在项目的哪个步骤,这就是我到目前为止所尝试的, approval.id, start_project.idleft join send_for_approval on send_for_approval.id_project=project.id
left join approval on ap