教师状态变更

SELECT
        t.teacher_name,
        t.teacher_no,
        t.teaching_department,
        t.subject_name,
        t.storage_time,
        ael.update_time 修改时间
FROM
        arranging_edit_log ael
LEFT JOIN
        bidata.zm_teacher_info t ON t.teacher_id = ael.teacher_id
WHERE
        ael.update_time >= '2019-03-01'
        and ael.update_time < '2019-07-01'
        and ael.suspend = 1
        and t.account_type = '正式'
        and t.quarters = '全职授课'
文档更新时间: 2019-08-19 11:54   作者:admin