[Spring/MyBatis] JOIN 구문 연습 (inner join, outer join, group by)
SQL 1. 부모테이블 : spring_department TABLE 생성 및 INSERT CREATE TABLE spring_department( deptno NUMBER PRIMARY KEY, dname VARCHAR2(100) NOT NULL, loc VARCHAR2(100) NOT NULL ) INSERT INTO spring_department VALUES(10, '전략기획', '판교'); INSERT INTO spring_department VALUES(20, '해양수산', '부산'); INSERT INTO spring_department VALUES(30, '공공사업', '판교'); 2. 자식테이블 : spring_employmentTABLE 생성 및 INSERT CREATE TABLE sp..
2020. 11. 3.