SQL 利用MySQL 抽取學會導師名單

你好﹗

請問是否可以在以下現有的SQL 上加入「學會導師」一欄？謝謝﹗

select
b.SCHYEAR '學年',
b.DURATION '時段',
f.CLASSLVL '級別',
f.CLASSCODE '班別',
f.CLASSNO '班號',
f.CHNAME '中文姓名',
f.ENNAME '英文姓名',
c.CH_DES '活動名稱',
d.CH_DES '職位',
e.CH_DES '表現',
(case when a.PRINTABLE = 1 then '是' else '' end) '可印在成績表' from TB_NAA_STUDENTNAA a

join TB_NAA_NAAOFFERED b
on a.SUID = b.SUID and a.NAAOFFEREDID = b.NAAOFFEREDID and b.SCHYEAR = ?

join TB_HSE_COMMON c
on a.SUID = c.SUID and b.NAACODE = c.CODE_ID and ((c.TB_ID = 'ECACD' and b.NAATYPE = 'E') or (c.TB_ID = 'INTERSCH' and b.NAATYPE = 'I') or (c.TB_ID = 'SEVPST' and b.NAATYPE = 'S'))

left outer join TB_HSE_COMMON d
on a.SUID = d.SUID and d.TB_ID = 'ECAPST' and a.NAAPOSTCODE = d.CODE_ID

left outer join TB_HSE_COMMON e
on a.SUID = e.SUID and e.TB_ID = 'ECAPFM' and a.NAAPERFCODE = e.CODE_ID

join VW_STU_LATESTSTUDENT f
on a.SUID = f.SUID and a.STUID = f.STUID and b.SCHYEAR = f.SCHYEAR order by b.DURATION, f.SCHLVL, f.SCHSESS, c.CH_DES, f.CLASSLVL, f.CLASSCODE, f.CLASSNO

 

老師請參考以下SQL語句: (紅色部分為新加部分)

 

謝謝教育局同事的回覆﹗