JOIN连接
SQL>select ename,deptno from emp;
ENAME DEPTNO
---------- ------
SMITH 20
ALLEN 30
WARD 30
JONES 20
MARTIN 30
BLAKE 30
CLARK 10
SCOTT 20
KING 10
TURNER 30
ADAMS 20
JAMES 30
FORD 20
MILLER 10
SQL>select dname,deptno from dept;
DNAME DEPTNO
-------------- ------
ACCOUNTING 10
RESEARCH 20
SALES 30
OPERATIONS 40