學生成績 未能抽取考績

本文由 tr-elsachoi 在 2021-04-27 發表於 "WebSAMS 討論區" 討論區

  1. 55883951

    tr-elsachoi
    Expand Collapse

    文章:
    3
    讚:
    0
    利用以下SQL, 只能抽取2019年度T1的考績, 但抽取不到T2考績。(已做了數據合併)

    select
    b.CLASSLVL '級別',
    b.CLASSCODE '班別',
    b.CLASSNO '班號',
    a.CHNAME '中文姓名',
    d.sysscore '中文',
    d1.sysscore '中文寫作',
    d2.sysscore '中文閱讀',
    d3.sysscore '中文聆聽',
    d5.sysscore '中文說話',
    e.sysscore '英文',
    e1.sysscore '英文寫作',
    e2.sysscore '英文閱讀',
    e3.sysscore '英文聽寫',
    e4.sysscore '英文說話',
    e6.sysscore '英文默書',
    f.sysscore '數學',
    g.sysscore '生社',
    h.sysscore '中史',
    i.sysscore '家政',
    j.sysscore '地理',
    k.sysscore '歷史',
    m.sysscore '科初',
    n.sysscore '設計',
    o.sysscore '體育',
    p.sysscore '電腦',
    q.sysscore '普通話',
    r.sysscore '視藝',
    s.sysscore '音樂',
    t.sysscore '生物',
    u.sysscore '化學',
    V.sysscore '物理',
    c.syspercscore '平均分',c.omclasslvl '級名次',c.omclass '班名次'
    from wsadmin.TB_STU_STUDENT a
    join wsadmin.VW_STU_LATESTSTUSCHREC b
    on a.SUID = b.SUID and a.STUID = b.STUID
    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 d.TIMESEQ = d1.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 d.TIMESEQ = d2.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d3
    on a.SUID = d3.SUID and a.SCHLVL = d3.SCHLEVEL and a.SCHSESS = d3.SCHSESSION and b.SCHYEAR = d3.SCHYEAR and a.STUID = d3.STUID and d.SUBJCODE = d3.SUBJCODE and d3.SUBJCOMPCODE = '03' and d.TIMESEQ = d3.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d5
    on a.SUID = d5.SUID and a.SCHLVL = d5.SCHLEVEL and a.SCHSESS = d5.SCHSESSION and b.SCHYEAR = d5.SCHYEAR and a.STUID = d5.STUID and d.SUBJCODE = d5.SUBJCODE and d5.SUBJCOMPCODE = '04' and d.TIMESEQ = d5.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 d.TIMESEQ = e.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 d.TIMESEQ = e1.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e2
    on a.SUID = e2.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 d.TIMESEQ = e2.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e3
    on a.SUID = e3.SUID and a.SCHLVL = e3.SCHLEVEL and a.SCHSESS = e3.SCHSESSION and b.SCHYEAR = e3.SCHYEAR and a.STUID = e3.STUID and e.SUBJCODE = e3.SUBJCODE and e3.SUBJCOMPCODE = '03' and d.TIMESEQ = e3.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e4
    on a.SUID = e4.SUID and a.SCHLVL = e4.SCHLEVEL and a.SCHSESS = e4.SCHSESSION and b.SCHYEAR = e4.SCHYEAR and a.STUID = e4.STUID and e.SUBJCODE = e4.SUBJCODE and e4.SUBJCOMPCODE = '04' and d.TIMESEQ = e4.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e6
    on a.SUID = e6.SUID and a.SCHLVL = e6.SCHLEVEL and a.SCHSESS = e6.SCHSESSION and b.SCHYEAR = e6.SCHYEAR and a.STUID = e6.STUID and e.SUBJCODE = e6.SUBJCODE and e6.SUBJCOMPCODE = '05' and d.TIMESEQ = e6.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 d.TIMESEQ = f.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 = '263' and d.TIMESEQ = g.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA h
    on a.SUID = h.SUID and a.SCHLVL = h.SCHLEVEL and a.SCHSESS = h.SCHSESSION and b.SCHYEAR = h.SCHYEAR and a.STUID = h.STUID and h.SUBJCODE = '075' and d.TIMESEQ = h.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA i
    on a.SUID = i.SUID and a.SCHLVL = i.SCHLEVEL and a.SCHSESS = i.SCHSESSION and b.SCHYEAR = i.SCHYEAR and a.STUID = i.STUID and i.SUBJCODE = '240' and d.TIMESEQ = i.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA j
    on a.SUID = j.SUID and a.SCHLVL = j.SCHLEVEL and a.SCHSESS = j.SCHSESSION and b.SCHYEAR = j.SCHYEAR and a.STUID = j.STUID and j.SUBJCODE = '210' and d.TIMESEQ = j.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA k
    on a.SUID = k.SUID and a.SCHLVL = k.SCHLEVEL and a.SCHSESS = k.SCHSESSION and b.SCHYEAR = k.SCHYEAR and a.STUID = k.STUID and k.SUBJCODE = '235' and d.TIMESEQ = k.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA m
    on a.SUID = m.SUID and a.SCHLVL = m.SCHLEVEL and a.SCHSESS = m.SCHSESSION and b.SCHYEAR = m.SCHYEAR and a.STUID = m.STUID and m.SUBJCODE = '260' and d.TIMESEQ = m.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA n
    on a.SUID = n.SUID and a.SCHLVL = n.SCHLEVEL and a.SCHSESS = n.SCHSESSION and b.SCHYEAR = n.SCHYEAR and a.STUID = n.STUID and n.SUBJCODE = '130' and d.TIMESEQ = n.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA o
    on a.SUID = o.SUID and a.SCHLVL = o.SCHLEVEL and a.SCHSESS = o.SCHSESSION and b.SCHYEAR = o.SCHYEAR and a.STUID = o.STUID and o.SUBJCODE = '310' and d.TIMESEQ = o.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA p
    on a.SUID = p.SUID and a.SCHLVL = p.SCHLEVEL and a.SCHSESS = p.SCHSESSION and b.SCHYEAR = p.SCHYEAR and a.STUID = p.STUID and p.SUBJCODE = '110' and d.TIMESEQ = p.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA q
    on a.SUID = q.SUID and a.SCHLVL = q.SCHLEVEL and a.SCHSESS = q.SCHSESSION and b.SCHYEAR = q.SCHYEAR and a.STUID = q.STUID and q.SUBJCODE = '350' and d.TIMESEQ = q.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA r
    on a.SUID = r.SUID and a.SCHLVL = r.SCHLEVEL and a.SCHSESS = r.SCHSESSION and b.SCHYEAR = r.SCHYEAR and a.STUID = r.STUID and r.SUBJCODE = '432' and d.TIMESEQ = r.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA s
    on a.SUID = s.SUID and a.SCHLVL = s.SCHLEVEL and a.SCHSESS = s.SCHSESSION and b.SCHYEAR = s.SCHYEAR and a.STUID = s.STUID and s.SUBJCODE = '300' and d.TIMESEQ = s.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA t
    on a.SUID = t.SUID and a.SCHLVL = t.SCHLEVEL and a.SCHSESS = t.SCHSESSION and b.SCHYEAR = t.SCHYEAR and a.STUID = t.STUID and t.SUBJCODE = '045' and d.TIMESEQ = t.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA u
    on a.SUID = u.SUID and a.SCHLVL = u.SCHLEVEL and a.SCHSESS = u.SCHSESSION and b.SCHYEAR = u.SCHYEAR and a.STUID = u.STUID and u.SUBJCODE = '070' and d.TIMESEQ = u.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA v
    on a.SUID = v.SUID and a.SCHLVL = v.SCHLEVEL and a.SCHSESS = v.SCHSESSION and b.SCHYEAR = v.SCHYEAR and a.STUID = v.STUID and v.SUBJCODE = '315' and d.TIMESEQ = v.TIMESEQ
    left outer join wsadmin.TB_ASR_STUDASSESSDATA c
    on a.SUID = c.SUID and a.SCHLVL = c.SCHLEVEL and a.SCHSESS = c.SCHSESSION and b.SCHYEAR = c.SCHYEAR and a.STUID = c.STUID and a.CLASSLVL=c.CLASSLEVEL and d.TIMESEQ = c.TIMESEQ
    where b.schyear = ? and b.classlvl=?
    order by b.CLASSCODE, b.CLASSNO
     

    附件文件:

    #1 tr-elsachoi, 2021-04-27
  2. 58521906

    edb-catherinewschan
    Expand Collapse

    文章:
    184
    讚:
    0
    中文科有入分嗎??? 試試以下的SQL, 看看有沒有資料

    select
    b.CLASSLVL '級別',
    b.CLASSCODE '班別',
    b.CLASSNO '班號',
    a.CHNAME '中文姓名',
    d.sysscore '中文',
    d1.sysscore '中文寫作',
    d2.sysscore '中文閱讀',
    d3.sysscore '中文聆聽',
    d5.sysscore '中文說話',
    e.sysscore '英文',
    e1.sysscore '英文寫作',
    e2.sysscore '英文閱讀',
    e3.sysscore '英文聽寫',
    e4.sysscore '英文說話',
    e6.sysscore '英文默書',
    f.sysscore '數學',
    g.sysscore '生社',
    h.sysscore '中史',
    i.sysscore '家政',
    j.sysscore '地理',
    k.sysscore '歷史',
    m.sysscore '科初',
    n.sysscore '設計',
    o.sysscore '體育',
    p.sysscore '電腦',
    q.sysscore '普通話',
    r.sysscore '視藝',
    s.sysscore '音樂',
    t.sysscore '生物',
    u.sysscore '化學',
    V.sysscore '物理',
    c.syspercscore '平均分',c.omclasslvl '級名次',c.omclass '班名次'
    from wsadmin.TB_STU_STUDENT a
    join wsadmin.VW_STU_LATESTSTUSCHREC b
    on a.SUID = b.SUID and a.STUID = b.STUID
    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 = 1200
    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 d.TIMESEQ = d1.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 d.TIMESEQ = d2.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d3
    on a.SUID = d3.SUID and a.SCHLVL = d3.SCHLEVEL and a.SCHSESS = d3.SCHSESSION and b.SCHYEAR = d3.SCHYEAR and a.STUID = d3.STUID and d.SUBJCODE = d3.SUBJCODE and d3.SUBJCOMPCODE = '03' and d.TIMESEQ = d3.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA d5
    on a.SUID = d5.SUID and a.SCHLVL = d5.SCHLEVEL and a.SCHSESS = d5.SCHSESSION and b.SCHYEAR = d5.SCHYEAR and a.STUID = d5.STUID and d.SUBJCODE = d5.SUBJCODE and d5.SUBJCOMPCODE = '04' and d.TIMESEQ = d5.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 d.TIMESEQ = e.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 d.TIMESEQ = e1.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e2
    on a.SUID = e2.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 d.TIMESEQ = e2.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e3
    on a.SUID = e3.SUID and a.SCHLVL = e3.SCHLEVEL and a.SCHSESS = e3.SCHSESSION and b.SCHYEAR = e3.SCHYEAR and a.STUID = e3.STUID and e.SUBJCODE = e3.SUBJCODE and e3.SUBJCOMPCODE = '03' and d.TIMESEQ = e3.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e4
    on a.SUID = e4.SUID and a.SCHLVL = e4.SCHLEVEL and a.SCHSESS = e4.SCHSESSION and b.SCHYEAR = e4.SCHYEAR and a.STUID = e4.STUID and e.SUBJCODE = e4.SUBJCODE and e4.SUBJCOMPCODE = '04' and d.TIMESEQ = e4.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJCOMASSESSDATA e6
    on a.SUID = e6.SUID and a.SCHLVL = e6.SCHLEVEL and a.SCHSESS = e6.SCHSESSION and b.SCHYEAR = e6.SCHYEAR and a.STUID = e6.STUID and e.SUBJCODE = e6.SUBJCODE and e6.SUBJCOMPCODE = '05' and d.TIMESEQ = e6.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 d.TIMESEQ = f.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 = '263' and d.TIMESEQ = g.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA h
    on a.SUID = h.SUID and a.SCHLVL = h.SCHLEVEL and a.SCHSESS = h.SCHSESSION and b.SCHYEAR = h.SCHYEAR and a.STUID = h.STUID and h.SUBJCODE = '075' and d.TIMESEQ = h.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA i
    on a.SUID = i.SUID and a.SCHLVL = i.SCHLEVEL and a.SCHSESS = i.SCHSESSION and b.SCHYEAR = i.SCHYEAR and a.STUID = i.STUID and i.SUBJCODE = '240' and d.TIMESEQ = i.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA j
    on a.SUID = j.SUID and a.SCHLVL = j.SCHLEVEL and a.SCHSESS = j.SCHSESSION and b.SCHYEAR = j.SCHYEAR and a.STUID = j.STUID and j.SUBJCODE = '210' and d.TIMESEQ = j.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA k
    on a.SUID = k.SUID and a.SCHLVL = k.SCHLEVEL and a.SCHSESS = k.SCHSESSION and b.SCHYEAR = k.SCHYEAR and a.STUID = k.STUID and k.SUBJCODE = '235' and d.TIMESEQ = k.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA m
    on a.SUID = m.SUID and a.SCHLVL = m.SCHLEVEL and a.SCHSESS = m.SCHSESSION and b.SCHYEAR = m.SCHYEAR and a.STUID = m.STUID and m.SUBJCODE = '260' and d.TIMESEQ = m.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA n
    on a.SUID = n.SUID and a.SCHLVL = n.SCHLEVEL and a.SCHSESS = n.SCHSESSION and b.SCHYEAR = n.SCHYEAR and a.STUID = n.STUID and n.SUBJCODE = '130' and d.TIMESEQ = n.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA o
    on a.SUID = o.SUID and a.SCHLVL = o.SCHLEVEL and a.SCHSESS = o.SCHSESSION and b.SCHYEAR = o.SCHYEAR and a.STUID = o.STUID and o.SUBJCODE = '310' and d.TIMESEQ = o.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA p
    on a.SUID = p.SUID and a.SCHLVL = p.SCHLEVEL and a.SCHSESS = p.SCHSESSION and b.SCHYEAR = p.SCHYEAR and a.STUID = p.STUID and p.SUBJCODE = '110' and d.TIMESEQ = p.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA q
    on a.SUID = q.SUID and a.SCHLVL = q.SCHLEVEL and a.SCHSESS = q.SCHSESSION and b.SCHYEAR = q.SCHYEAR and a.STUID = q.STUID and q.SUBJCODE = '350' and d.TIMESEQ = q.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA r
    on a.SUID = r.SUID and a.SCHLVL = r.SCHLEVEL and a.SCHSESS = r.SCHSESSION and b.SCHYEAR = r.SCHYEAR and a.STUID = r.STUID and r.SUBJCODE = '432' and d.TIMESEQ = r.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA s
    on a.SUID = s.SUID and a.SCHLVL = s.SCHLEVEL and a.SCHSESS = s.SCHSESSION and b.SCHYEAR = s.SCHYEAR and a.STUID = s.STUID and s.SUBJCODE = '300' and d.TIMESEQ = s.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA t
    on a.SUID = t.SUID and a.SCHLVL = t.SCHLEVEL and a.SCHSESS = t.SCHSESSION and b.SCHYEAR = t.SCHYEAR and a.STUID = t.STUID and t.SUBJCODE = '045' and d.TIMESEQ = t.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA u
    on a.SUID = u.SUID and a.SCHLVL = u.SCHLEVEL and a.SCHSESS = u.SCHSESSION and b.SCHYEAR = u.SCHYEAR and a.STUID = u.STUID and u.SUBJCODE = '070' and d.TIMESEQ = u.TIMESEQ
    left outer join wsadmin.TB_ASR_SUBJASSESSDATA v
    on a.SUID = v.SUID and a.SCHLVL = v.SCHLEVEL and a.SCHSESS = v.SCHSESSION and b.SCHYEAR = v.SCHYEAR and a.STUID = v.STUID and v.SUBJCODE = '315' and d.TIMESEQ = v.TIMESEQ
    left outer join wsadmin.TB_ASR_STUDASSESSDATA c
    on a.SUID = c.SUID and a.SCHLVL = c.SCHLEVEL and a.SCHSESS = c.SCHSESSION and b.SCHYEAR = c.SCHYEAR and a.STUID = c.STUID and a.CLASSLVL=c.CLASSLEVEL and d.TIMESEQ = c.TIMESEQ
    where b.schyear = 2019
    order by b.CLASSCODE, b.CLASSNO
     
    #2 edb-catherinewschan, 2021-04-27
  3. 55883951

    tr-elsachoi
    Expand Collapse

    文章:
    3
    讚:
    0
    T2 成績成功抽取,但當 d.TIMESEQ = 1200 改了 d.TIMESEQ = 1201 , 又出五到資料。
     
    #3 tr-elsachoi, 2021-04-27
  4. 58521906

    edb-catherinewschan
    Expand Collapse

    文章:
    184
    讚:
    0
    你在WEBSAMS 的 學生成績 > 查詢 > 學生成績 , 看看T2A1 有沒有分數, 尤其是中文科....
     
    #4 edb-catherinewschan, 2021-04-27