oracle笛卡尔积与等值连接

要显示雇员名，雇员工资及所在部门的名字

第一步：select * from emp a1,dept a2

没有连接条件的返回结果会形成笛卡尔积，结果如下。很多生成的记录是没有意义的。

	EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO	DETPNO	DNAME	LOC
1	7369	SMITH	CLERK	7902	1980/12/17	800		20	10	ACCOUNTING	NEW YORK
2	7499	ALLEN	SALESMAN	7698	1981/2/20	1600	300	30	10	ACCOUNTING	NEW YORK
3	7521	WARD	SALESMAN	7698	1981/2/22	1250	500	30	10	ACCOUNTING	NEW YORK
4	7566	JONES	MANAGER	7839	1981/4/2	2975		20	10	ACCOUNTING	NEW YORK
5	7654	MARTIN	SALESMAN	7698	1981/9/28	1250	1400	30	10	ACCOUNTING	NEW YORK
6	7698	BLAKE	MANAGER	7839	1981/5/1	2850		30	10	ACCOUNTING	NEW YORK
7	7782	CLARK	MANAGER	7839	1981/6/9	2450		10	10	ACCOUNTING	NEW YORK
8	7788	SCOTT	ANALYST	7566	1987/4/19	1500		20	10	ACCOUNTING	NEW YORK
9	7839	KING	PRESIDENT		1981/11/17	5000		10	10	ACCOUNTING	NEW YORK
10	7844	TURNER	SALESMAN	7698	1981/9/8	1500	0	30	10	ACCOUNTING	NEW YORK
11	7876	ADAMS</