>>> >>>SELECT Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*)as nowork,; >>> Student.sex; >>> FROM ; >>> student ; >>> left JOIN hwsv ; >>> ON Student.code = Hwsv.code; >>> WHERE Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value and Hwsv.perc<50 AND student.admtd=1 AND student.joind<CTOD("20/06/2010") ; >>> ORDER BY hwsv.lcode; >>> GROUP BY hwsv.lcode,hwsv.sec; >>> INTO cursor nowork >>> >>> brows >>> SELECT Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*) as completee,; >>> Student.sex; >>> FROM ; >>> student ; >>> left JOIN hwsv ; >>> ON Student.code = Hwsv.code; >>> WHERE Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value AND Hwsv.perc =100 and student.admtd=1 AND student.joind<CTOD("20/06/2010"); >>> GROUP BY hwsv.lcode,hwsv.sec; >>> ORDER BY hwsv.lcode; >>> INTO cursor com >>> brows >>> >>> >>> >>> SELECT Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*) as incompl ,; >>> Student.sex; >>> FROM ; >>> student ; >>> left JOIN hwsv ; >>> ON Student.code = Hwsv.code; >>> WHERE Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value AND Hwsv.perc <100 and Hwsv.perc>49 AND student.admtd=1 AND student.joind<CTOD("20/06/2010"); >>> GROUP BY hwsv.lcode,hwsv.sec; >>> ORDER BY hwsv.lcode; >>> INTO CURSOR incom >>> >>> >>>SELECT Com.*, Incom.*, Nowork.*; >>> FROM ; >>> com ; >>> LEFT JOIN incom ; >>> ON Com.scode = Incom.scode; >>> AND Com.lcode = Incom.lcode; >>> AND Com.sec = Incom.sec ; >>> left JOIN nowork ; >>> ON Com.scode = Nowork.scode; >>> AND Incom.lcode = Nowork.lcode; >>> AND Incom.sec = Nowork.sec; >>> INTO CURSOR ghu10cc >>>>some result is missing from first query