SQL Statement:
SELECT Person.loginid, Person.last-(", "+Person.first) AS fullname,;
  Enroll.enrollid, Programlist.programname, {} AS startdate, {} AS enddate,;
  Courses.courseid, Courselist.programcode AS coursecode,;
  Courses.exclattend, Termcourse.crsschedid, Attendance.attendid,;
  Schedulehours.hourcode, Roomslist.roomcode, Teacherlist.teachername,;
  Attendance.date, Attendance.attendcode, SPACE(100) AS attendance;
 FROM FORCE smagic!termcourse ;
    INNER JOIN smagic!attendance ;
   ON  Attendance.crsschedid = Termcourse.crsschedid ;
    INNER JOIN smagic!courses ;
   ON  Termcourse.termcrsid = Courses.termcrsid ;
    INNER JOIN smagic!programlist ;
   ON  Termcourse.courseid = Programlist.programid ;
    INNER JOIN smagic!programlist Courselist ;
   ON  Courses.programid = Courselist.programid ;
    INNER JOIN smagic!enroll ;
   ON  Enroll.enrollid = Courses.enrollid;
   AND  Attendance.enrollid = Enroll.enrollid ;
    INNER JOIN smagic!person ;
   ON  Person.personid = Enroll.personid ;
    INNER JOIN smagic!roomslist ;
   ON  Termcourse.roomid = Roomslist.roomid ;
    INNER JOIN smagic!schedulehours ;
   ON  Termcourse.hourid = Schedulehours.hourid ;
    INNER JOIN smagic!teacherlist ;
   ON  Termcourse.teacherid = Teacherlist.teacherid;
 WHERE (  Termcourse.crsschedid = ( ?vp_crsschedid );
   AND  Enroll.scheduleid = ( ?vp_scheduleid ) );
   AND  Attendance.date = ( ?vp_date );
 ORDER BY Schedulehours.hourcode, Roomslist.roomcode, 2