谭冬平教师信息匹配

SELECT
    u.name 教师姓名,
    t.teacher_id  教师ID,
    (select  group_concat(grade_rank)  from  teacher_grade_rank_rel  where  teacher_id=t.teacher_id)  年级,
    (select group_concat(subject_name) from subject where subject_id in (select subject_id from teacher_subject_rel where teacher_id =t.teacher_id)) 授课学科,
    (case  when  t.quarters_type  =1  then  '全职授课'
    when  t.quarters_type  =2  then  '全职教研'
    when  t.quarters_type  =3  then  '兼职教学'
    when  t.quarters_type  =4  then  '实习'
    when  t.quarters_type  =5  then  '教师体验课'  
    end  )  教师职位
FROM
    view_teacher  t
left join
    view_user_info u on u.user_id = t.teacher_id
WHERE
    t.teacher_id  in  ()
文档更新时间: 2019-03-08 11:44   作者:admin