Student <student header info>
        <graduation plan for the student>

    Department <dept header info>

         Course  <course info>
                 <indicate if it is required by grad plan>
               
             (Detail)  Grades and credits earned in the course

    Deparment subtotals (i.e., required vs taken)

Student subtotals
<page break before next student>

SELECT student.stu_num, student.last_name, student.first_name, 
       student.middle_initial, student.date_of_birth, 
       student.ged_wri, student.ged_rdg, student.ged_math, 
       student.ged_ss, student.ged_sci, student.exit_math,
       student.exit_rdg, student.exit_wri, student.gradplan, 
       student.concurrent_site, student.evetel, student.daytel, 
       course.title, department.deptname
FROM   department 
INNER JOIN course ON department.deptname = dbo.course.deptname
CROSS JOIN student

SELECT AllStudentsAllCourses.*, transcript.grade, 
       transcript.credits_earned, transcript.completion_date, 
       transcript.title AS CourseTaken, plan_requirment.title AS 
       RequiredCourse, plan_requirment.credits_req
FROM   AllStudentsAllCourses 
LEFT JOIN plan_requirment 
   ON AllStudentsAllCourses.gradplan = plan_requirment.gradplan 
LEFT JOIN transcript 
   ON AllStudentsAllCourses.stu_num = transcript.stu_num AND dbo.transcript.verified IS NOT NULL