Subject group codes

本文由 P 在 2010-05-31 發表於 "WebSAMS 討論區" 討論區

  1. 55078230

    P
    Expand Collapse

    文章:
    1
    讚:
    0

    We put our F.1 students in cross-class subject groups (non-subject block) for Chinese and English.

    Can I extract a list of students by class with their group numbers for this two subjects using SQL?

    Please help.

     

     
  2. 56127239

    EDB-Wayne
    Expand Collapse

    文章:
    0
    讚:
    0

    Please try the below SQL statement:

    select
       a.classcode,
       a.classno,
       a.chname,
       c.ch_des,
       b.crosssubjcode
    from vw_stu_lateststudent a
    join tb_stu_stusubj b
       on a.suid=b.suid and a.stuid=b.stuid and a.stuschrecid=b.stuschrecid and b.clssubjtype='X'
    join tb_hse_common c
       on a.suid=c.suid and b.subjcode=c.code_id and c.tb_id='SBJ'
    where a.schyear=? and a.classlvl='S1'
    order by a.classcode, a.classno

    Parameter: a.schyear=School Year(e.g. 2009)

     
    #2 EDB-Wayne, 2010-05-31