SQL SQL抽不到六年級中英數常科及分卷分數及等級

各位同工：
本校使用以下SQL抽取本任何一年度學生中英數常科及其分卷分數和等級成績。僅抽到P1-P5年級數據，唯有P6年級抽取不到。是SQL問題還是Websams 數據問題？
以下是sql 碼，請各同工賜教：

select
b.CLASSLVL '級別',
b.CLASSCODE '班別',
b.CLASSNO '班號',
a.ENNAME '英文姓名',
a.CHNAME '中文姓名',

d.sysscore '中文成績',
d.SYSGRADECONVCOMPCODE '中文等級',
d1.sysscore '中文閱讀',
d1.SYSGRADECONVCOMPCODE '中文閱讀等級',
d2.sysscore '中文寫作',
d2.SYSGRADECONVCOMPCODE '中文寫作等級',

e.sysscore '英文成績',
e.SYSGRADECONVCOMPCODE '英文等級',
e1.sysscore '英文閱讀成績',
e1.SYSGRADECONVCOMPCODE '英文閱讀等級',
e2.sysscore '英文寫作成績',
e2.SYSGRADECONVCOMPCODE '英文寫作等級',

f.sysscore '數學成績',
f.SYSGRADECONVCOMPCODE '數學等級',
f1.sysscore '數一',
f1.SYSGRADECONVCOMPCODE '數一等級',
f2.sysscore '數二',
f2.SYSGRADECONVCOMPCODE '數二等級',

g.sysscore '常識科成績',
g.SYSGRADECONVCOMPCODE '常識科等級'

from wsadmin.TB_STU_STUDENT a
join wsadmin.VW_STU_LATESTSTUSCHREC b
on a.SUID = b.SUID and a.STUID = b.STUID and b.SCHYEAR = ?

left outer join wsadmin.TB_ASR_SUBJASSESSDATA d
on a.SUID = d.SUID and a.SCHLVL = d.SCHLEVEL and a.SCHSESS = d.SCHSESSION and b.SCHYEAR = d.SCHYEAR and a.STUID = d.STUID and d.SUBJCODE = '080' and d.TIMESEQ = ?

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d1
on a.SUID = d1.SUID and A.SCHLVL = d1.SCHLEVEL and a.SCHSESS = d1.SCHSESSION and b.SCHYEAR = d1.SCHYEAR and a.STUID = d1.STUID and d.SUBJCODE = d1.SUBJCODE and d1.SUBJCOMPCODE = '01' and d1.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d2
on a.SUID = d2.SUID and A.SCHLVL = d2.SCHLEVEL and a.SCHSESS = d2.SCHSESSION and b.SCHYEAR = d2.SCHYEAR and a.STUID = d2.STUID and d.SUBJCODE = d2.SUBJCODE and d2.SUBJCOMPCODE = '02' and d2.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJASSESSDATA e
on a.SUID = e.SUID and a.SCHLVL = e.SCHLEVEL and a.SCHSESS = e.SCHSESSION and b.SCHYEAR = e.SCHYEAR and a.STUID = e.STUID and e.SUBJCODE = '165' and e.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e1
on a.SUID = e1.SUID and A.SCHLVL = e1.SCHLEVEL and a.SCHSESS = e1.SCHSESSION and b.SCHYEAR = e1.SCHYEAR and a.STUID = e1.STUID and e.SUBJCODE = e1.SUBJCODE and e1.SUBJCOMPCODE = '01' and e1.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e2
on a.SUID = e1.SUID and A.SCHLVL = e2.SCHLEVEL and a.SCHSESS = e2.SCHSESSION and b.SCHYEAR = e2.SCHYEAR and a.STUID = e2.STUID and e.SUBJCODE = e2.SUBJCODE and e2.SUBJCOMPCODE = '02' and e2.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJASSESSDATA f
on a.SUID = f.SUID and a.SCHLVL = f.SCHLEVEL and a.SCHSESS = f.SCHSESSION and b.SCHYEAR = f.SCHYEAR and a.STUID = f.STUID and f.SUBJCODE = '280' and f.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA f1
on a.SUID = f1.SUID and A.SCHLVL = f1.SCHLEVEL and a.SCHSESS = f1.SCHSESSION and b.SCHYEAR = f1.SCHYEAR and a.STUID = f1.STUID and f.SUBJCODE = f1.SUBJCODE and f1.SUBJCOMPCODE = '01' and f1.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA f2
on a.SUID = f2.SUID and A.SCHLVL = f2.SCHLEVEL and a.SCHSESS = f2.SCHSESSION and b.SCHYEAR = f2.SCHYEAR and a.STUID = f2.STUID and f.SUBJCODE = f2.SUBJCODE and f2.SUBJCOMPCODE = '02' and f2.TIMESEQ = d.TIMESEQ

left outer join wsadmin.TB_ASR_SUBJASSESSDATA g
on a.SUID = g.SUID and a.SCHLVL = g.SCHLEVEL and a.SCHSESS = g.SCHSESSION and b.SCHYEAR = g.SCHYEAR and a.STUID = g.STUID and g.SUBJCODE = '205' and g.TIMESEQ = d.TIMESEQ

order by b.SCHLVL, b.SCHSESS, b.CLASSLVL, b.CLASSCODE, b.CLASSNO

 

老師可以在學生成績模組將相關數據匯出。

當系統已更新至3.0.0.27082018的版本，可以按科目提取成績，並可選擇匯出的資料（分數、等級或名次）。

路徑如下：
學生成績 > 數據合併 > 匯出資料

如有進一步的查詢，可與學校聯絡主任聯繫。