/* Join all 5 tables to validate successful create/load ###################################### */ SELECT c.course_id, c.description, cl.session_id, i.fname, i.lname, s.fname, s.lname, a.street1 from course c, class cl, instructor i, student s, address a where c.course_id = cl.course_id and i.ssn = cl.inst_ssn and s.ssn = cl.stu_ssn and s.student_id = a.stu_id order by c.description, cl.session_id, s.lname