| sql 92 | sql 99 | |||
| 카르티잔 곱 | select * from emp,dept | 크로스 조인 | select * from emp cross join dept | |
| equi-join | select e.ename,d.dname from emp e, dept d where e.deptno=d.deptno |
natural-join | select e.ename,d.dname from emp e natural join dept d | |
| join using | select e.ename,d.dname from emp e join dept d using(deptno) | |||
| join on | select e.ename,d.dname from emp e join dept d on e.deptno = d.deptno | |||
| outer join | select e.ename,d.dname from emp e, dept d where e.deptno(+)=d.deptno |
outer join | select e.ename,d.dname from emp e right outer join dept d using(deptno) | |
| select e.ename,d.dname from emp e, dept d where d.deptno=e.deptno(+) |
select e.ename,d.dname from dept d left outer join emp e using(deptno) | |||
| select e.ename,d.dname from dept d full outer join emp e using(deptno) | ||||
|
|
