[G_SQL] p.149 : 다섯 개의 테이블에서 조인하기

-- 각 선생님별로 가르치는 과목의 학생명단을 작성하라.

SELECT teacher_name, course_name, student_name

FROM TEACHERS, SECTIONS, COURSES, ENROLLS, STUDENTS 

WHERE TEACHERS.teacher = SECTIONS.teacher AND

SECTIONS.course = COURSES.course AND

SECTIONS.section = ENROLLS.section AND

SECTIONS.course = ENROLLS.course AND

ENROLLS.student = STUDENTS.student 

ORDER BY teacher_name;

-- [G_SQL] p.149 : 다섯 개의 테이블에서 조인하기
-- 각 선생님별로 가르치는 과목의 학생명단을 작성하라. (INNER JOIN 버전)
SELECT teacher_name, course_name, student_name
FROM ((TEACHERS
            INNER JOIN SECTIONS
            ON TEACHERS.teacher = SECTIONS.teacher )
        INNER JOIN COURSES
        ON SECTIONS.course = COURSES.course )
    INNER JOIN (ENROLLS
        INNER JOIN STUDENTS
        ON ENROLLS.student = STUDENTS.student )
    ON (SECTIONS.section = ENROLLS.section ) AND
        (SECTIONS.course = ENROLLS.course)
ORDER BY TEACHERS.teacher_name;