外文系教學組系所教師總覽:130學年度第1學期

SELECT DISTINCT ps1.e_account, ps1.emp_name_web, ps1.pos_desc, ps1.beg_date, ps1.end_date, ps1.emp_no, majr.majr_name_rev FROM ps1.emp_pos_v_ccsd ps1 , center.the3majr majr WHERE ps1.majr_no = majr.majr_no AND ps1.majr_no = '121' AND ps1.teac_code != ' ' AND ps1.beg_date < 1080922 AND ps1.end_date > 1080922 ORDER BY ps1.beg_date
教師姓名 教師職稱 任職系所 專長領域