SELECT Subjects.subjcode, Subjects.subjname, Attendnc.passed,;
     Attendnc.att_part,Attendnc.absent, Attendnc.rpl,;
     Attendnc.concldate, SPACE(60) AS lect_name, Attendnc.withdrawn,;
     Attendnc.completed, Subjects.subject_id, Attendnc.enrol_id,;
     Enrolmts.su_stdate, Attendnc.memb_num, Attendnc.lect_num;
     FROM attendnc ;
        INNER JOIN subjects ;
          ON Attendnc.subject_id=Subjects.subject_id;
        INNER JOIN enrolmts;
          ON Attendnc.enrol_id=Enrolmts.enrol_id;
     WHERE Attendnc.course_id=CF.course_id .AND.;
           Attendnc.memb_num=Stu2.memb_num .AND.;
           ATTENDNC.ENROL_ID=CF.ENROL_ID .AND. &ATT_COND.;
     ORDER BY Subjects.subjcode, Subjects.subject_id ;
     INTO CURSOR ATTTMP