oracle 自表笛卡尔积,数据库Oracle之多表查询：笛卡尔积、等值连接、不等值连接、外连接，自连接...

eg:查询员工信息,员工号,姓名,月薪,薪水级别select  e.empno, e.ename, e.sal, s.grade

from emp e, SALGRADE s

where e.sal >= s.losal and e.sal <= s.hisal

-- where e.sal between s.losal and s.hisal

EMPNOENAME            SAL      GRADE

---------- ---------- ---------- ----------

7369 SMITH            800          1

7900JAMES            950          1

7876ADAMS           1100          1

7521WARD            1250          2

7654MARTIN          1250          2

7934MILLER          1300          2

7844TURNER          1500          3

7499ALLEN           1600          3

7782CLARK           2450          4

7698BLAKE           2850          4

7566JONES           2975          4

7788 SCOTT           3000          4

7902FORD            3000          4

7839KING            5000          5已选择14行。4、外连接