[오라클DB] 테이블 합치기 INNER JOIN

 

Student 테이블

 

Subject 테이블

 

Enrol 테이블

---

결과창

SELECT E.*, S.STU_NAME, B.SUB_NAME
FROM ENROL E
INNER JOIN STUDENT S ON S.STU_NO = E.STU_NO
INNER JOIN SUBJECT B ON B.SUB_NO = E.SUB_NO;