[今日のクエリ]USINGセクション

SELECT E.ENAME AS 이름, E.JOB AS 직업, E.SAL AS 월급, D.LOC AS '부서 위치'
	FROM EMP E JOIN DEPT D
    USING(DEPTNO)
    WHERE E.JOB = 'SALESMAN';

結果

氏名|職業|給与|部門ポジション
MARTIN | SALESMAN | 1250 | CHICAGO
ALLEN | SALESMAN | 1600 | CHICAGO
TURNER | SALESMAN | 1500 | CHICAGO
WARD | SALESMAN | 1250 | CHICAGO

USING寺院内DEPTNOの前に表名や表名は使用できません.