#### 日期:2019-01-18
#### 需求方:伦红叶
#### 数据输出方式:excel
#### created by:汪国强

SELECT
    t.teacher_no 教师编号,
    t.email_personal 教师邮箱,
    (select hrm_teacher_id from jx_teacher_hrm_id where teacher_id=t.teacher_id) HRMid
FROM
    view_teacher t
WHERE
    t.teacher_no in ('EN612473','PH435086')
文档更新时间: 2019-03-08 11:44   作者:admin