1. ANSI JOIN ※ INNER JOIN(내부조인, 교집합) 1) NATURAL JOIN (자연조인) 자연조인의 사용예) SELECT STUDNO, NAME, DEPTNO, DNAME FROM STUDENT NATURAL JOIN DEPARTMENT; -- 자연조인 사용 2) USING SELECT STUDNO, NAME, DEPTNO, DNAME FROM STUDENT JOIN DEPARTMENT USING(DEPTNO); 3) ON (?와 ?가 같을때) SELECT STUDNO, NAME, STUDENT.DEPTNO, DNAME FROM STUDENT JOIN DEPARTMENT ON STUDENT.DEPTNO = DEPARTMENT.DEPTNO WHERE NAME = '전인하'; ※참고 앞에서..
