개발노트

OUTER JOIN한 쪽 테이블 기준으로 조인 기준 테이블을 불러오고, 다른쪽 테이블을 추가한다.기준이 되는 반대쪽에다가(+) 기호 추가SELECT A.STADIUM_NAME, A.STADIUM_ID, B.STADIUM_ID, B.TEAM_NAMEFROM STADIUM A, TEAM BWHERE B.STADIUM_ID(+) = A.STADIUM_ID;

CROSS  JOIN : 양쪽 테이블의 모든 조합-- 가상의 테이블 생성WITH SALGRADE AS ( SELECT 1 GRADE, 700 LOSAL, 1200 HISAL FROM DUAL UNION ALL SELECT 2 GRADE, 1201 LOSAL, 1400 HISAL FROM DUAL UNION ALL SELECT 3 GRADE, 1401 LOSAL, 2000 HISAL FROM DUAL UNION ALL SELECT 4 GRADE, 2001 LOSAL, 3000 HISAL FROM DUAL UNION ALL SELECT 5 GRADE, 3001 LOSAL, 9999 HISAL FROM DUAL)-- 조건을 주지 않고 JOIN하면 CROSS..