提供教师编号,需要教师的邮箱、HRMid

#### 日期:2019-02-11
#### 需求方:伦红叶
#### 数据输出方式: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  ()
文档更新时间: 2019-03-08 11:44   作者:admin