SELECT supervision.*,teacher.firstname, student.firstname, school.school_name
FROM supervision,teacher,student,school
WHERE supervision.teacher_id=teacher.teacher_id
AND supervision.studentid=student.studentid
AND supervision.school_id=school.school_id
ORDER BY term ASC
