개발/DB
DB_Oracle,SQL ANSI JOIN(SQL-99 표준문법 조인), JOIN ~ ON, OUTER JOIN
ANSI JOIN(SQL-99 표준문법 조인) DBMS 공통 표준 문법 JOIN ~ USING SELECT E.EMPNO, E.ENAME, E.JOB, E.MGR, E.HIREDATE, E.SAL, E.COMM, DEPTNO, D.DNAME, D.LOC FROM EMP E JOIN DEPT D USING (DEPTNO) WHERE SAL > = 3000 ORDER BY DEPTNO, E.EMPNO; JOIN ~ ON : 기존 WHERE절 조인 조건식을 ON 옆에 작성 SELECT E.EMPNO, E.ENAME, E.JOB, E.MGR, E.HIREDATE, E.SAL, E.COMM, E.DEPTNO, D.DNAME, D.LOC FROM EMP E JOIN DEPT D ON (E.DEPTNO = D.DEP..
2021. 11. 8.