oracle多表联查之连接(1)

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