Dear all, I want to extract from WebSAMS by SQL 1) all S4-6 OLE records. 2) all S4-6 performance outside school. Thank you!
Sorry, what I want is the SQL really extracting 1) all S4-6 OLE records. 2) all S4-6 performance outside school. in the module SLP, is it possible?
Pls try the below SQL, they extact data from SLP module only. 1) SELECT a.schyear, a.classlvl, a.CLASSCODE, a.CLASSNO, a.chname, a.ENNAME, b.STARTYR, b.ENDYR, b.PROG_ENG, b.PROG_DESC_ENG, b.ROLE_ENG, b.ORG_ENG, b.AWARD_ENG, b.MAJOR_ENG, c.seq FROM TB_SLP_STU_OLE_FROMSLP b, VW_STU_LATESTSTUDENT a, TB_SLP_OLE_SEQ c WHERE a.STUID = b.STUID and b.stuid = c.stuid and b.ole_id = c.code_id and c.tb_id = 'SLP' and a.schyear=? ORDER BY 2,3,4 2) select d1.schyear, d1.classlvl, d1.classcode, d1.classno, d1.chname, d1.enname, c1.STARTYR, c1.ENDYR, c1.PROG, c1.PROG_DES, c1.ROLE, c1.ORG, c1.AWARD, c1.SEQ from TB_SLP_STU_PERFME_OUTSCH c1 join vw_stu_lateststudent d1 on c1.suid=d1.suid and c1.stuid=d1.stuid where d1.schyear=? order by 2,3,4