left join2 [Oracle] JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, (+) WHERE 절 JOIN SELECT t1.ename, t1.sal, T2.* FROM emp t1, salgrade T2 WHERE t1.sal BETWEEN T2.losal AND T2.hisal; WHERE 절 JOIN하기 옵션 (+) 방법 - 오라클만 가능 select d.dname, l.city from dept d, locations l where d.loc_code = l.loc_code(+); (+)가 없는 테이블 ROW가 전체 출력 됨, DEPT DNAME > INSA 정보까지 보기 위해, locations 테이블에 (+) 함 LEFT JOIN, RIGHT JOIN SELECT D.DNAME, L.LOC_CODE FROM DEPT D LEFT JOIN LOCATIONS L -- FROM D.. 2021. 4. 18. [Oracle] JOIN / LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN 기본 테이블 조회 select * from TB_GRADE; select * from TB_CLASS_INFO; Join select * from TB_GRADE A, TB_CLASS_INFO B where A.class_cd = B.class_cd; select * from TB_GRADE A join TB_CLASS_INFO B on A.class_cd = B.class_cd; 테이블 조회 select * from TB_GRADE_08; select * from TB_GRADE_09; SELECT * FROM tb_grade_08 A JOIN tb_grade_09 B ON A.test_cd = B.test_cd; SELECT * FROM tb_grade_08 A LEFT JOIN tb_grade_09.. 2021. 4. 9. 이전 1 다음
