經濟系一經組系所教師總覽:220學年度第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 = '521' AND ps1.teac_code != ' ' AND ps1.beg_date < 1081016 AND ps1.end_date > 1081016 ORDER BY ps1.beg_date
教師姓名 教師職稱 任職系所 專長領域