UPDATE applyinfo a
LEFT JOIN enterprise_applicant e ON a.app_ent_id = e.id
SET a.`status` = 9
WHERE
e.enterprise_name = 'test'
AND a.create_date >= '2017-05-18'
AND a.`status` = 1
LEFT JOIN enterprise_applicant e ON a.app_ent_id = e.id
SET a.`status` = 9
WHERE
e.enterprise_name = 'test'
AND a.create_date >= '2017-05-18'
AND a.`status` = 1
扫一扫
5046
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
