[Oracle] JOIN (3) 비등가 조인(NON EQUAL JOIN)

    3. 비등가 조인 (NON EQUAL JOIN) => 얘는 그냥 참고용

    매칭시킬 컬럼에 대한 조건 작성시 '=(등호)' 를 사용하지 않는 조인문
    ANSI 구문으로는 JOIN ON만 사용 가능

---

EMLPLOYEE TABLE

SAL_GRADE TABLE

---

-- 사원명, 급여, 최대 월급 한도

-->> 오라클 구문

SELECT EMP_NAME, SALARY, MAX_SAL
FROM EMPLOYEE, SAL_GRADE
--WHERE SALARY >= MIN_SAL AND SALARY <= MAX_SAL;
WHERE SALARY BETWEEN MIN_SAL AND MAX_SAL;

 

-->> ANSI 구문

SELECT EMP_NAME, SALARY, MAX_SAL
FROM EMPLOYEE
JOIN SAL_GRADE ON (SALARY BETWEEN MIN_SAL AND MAX_SAL);