SQL> select a.ename,c.ename from a left outer join c on a.ename=c.ename;ENAME ENAME
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORD11 rows selected.SQL> select a.ename,c.ename from a right outer join c on a.ename=c.ename;ENAME ENAME
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORDENAME ENAME
---------- ---------- MILLER
CLARK
KING
liq16 rows selected.SQL> select a.ename,c.ename from a full outer join c on a.ename=c.ename;ENAME ENAME
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORDENAME ENAME
---------- ----------
CLARK
KING
MILLER
liq
16 rows selected.SQL>
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORD11 rows selected.SQL> select a.ename,c.ename from a right outer join c on a.ename=c.ename;ENAME ENAME
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORDENAME ENAME
---------- ---------- MILLER
CLARK
KING
liq16 rows selected.SQL> select a.ename,c.ename from a full outer join c on a.ename=c.ename;ENAME ENAME
---------- ----------
SMITH SMITH
ALLEN ALLEN
WARD WARD
JONES JONES
MARTIN MARTIN
BLAKE BLAKE
SCOTT SCOTT
TURNER TURNER
ADAMS ADAMS
JAMES JAMES
FORD FORDENAME ENAME
---------- ----------
CLARK
KING
MILLER
liq
16 rows selected.SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货