左外连接:左表A与左表B左外连接时,A表显示全部数据(符合与不符合都显示),B表只显示符合条件的数据
1、select e.empno,e.ename,d.deptno,d.dname from emp e left outer join dept d on e.deptno = d.deptno;
2、select e.empno,e.ename,d.deptno,d.dname from emp e, dept d where e.deptno = d.deptno(+);
右外连接:左表A与左表B右外连接时,A表只显示符合条件的数据,B表显示全部数据(符合与不符合都显示)
1、select e.empno,e.ename,d.deptno,d.dname from emp e right outer join dept d on e.deptno = d.deptno;
2、select e.empno,e.ename,d.deptno,d.dname from emp e, dept d where e.deptno(+) = d.deptno;
全外链接:左表A与左表B全外连接时,A表与B表显示全部数据(符合与不符合都显示)
select e.empno,e.ename,d.deptno,d.dname from emp e full outer join dept d on e.deptno = d.deptno;