成天的需求

SELECT
        t.teacher_no,
        t.linkman,
        t.linkman_relation,
        t.linkman_phone,
        case when ael.start_time is not null then ( case ael.reson when 1 then '学术阶段性停课' when 2 then '离职交接中' when 3 then ' 其他原因阶段性停课'  else ael.reson end  )else null end 阶段性停课原因
FROM
        view_teacher t
LEFT JOIN
        arranging_edit_log ael on t.teacher_id = ael.teacher_id
WHERE
        t.teacher_no in ()
文档更新时间: 2019-08-19 11:45   作者:admin