oracle_非等值连接(国外英文资料).docVIP

oracle_非等值连接(国外英文资料) -- multiple table queries -- Equivalent connection Two - non equivalent connection - output employee number, name, salary, salary grade Select, e.empno, e.ename, e.sal, s.grade From, EMP, e, salgrade, s Where, e.sal, between, s.losal, and, s.hisal; Select, e.empno, e.ename, e.sal, s.grade From, EMP, e, salgrade, s Where e.sal=s.losal and e.sal=s.hisal; * Connection classification: 1- can be divided into equivalent and non equivalent connections from the connection values of multiple tables whose connection values are equal 2- connects the query from multiple tables to the same table, and is divided into regular join queries and self join queries 3- satisfaction of the row filter condition for the query from the result set: Fully satisfying the connection condition is called inner join, It not only displays the set of results satisfying the connection condition, but also shows that the result set that is not qualified is called an external connection Note: the outer join is not a Descartes product, and the Descartes product is a full match of each row. External connections are displayed only on rows that do not meet the criteria, and no matches will be made. * / - show all employee information, and information about the Department, as well as department information with no staff Select, e.*, d.* From, EMP, e, Dept, D Where e.deptno (+) = d.deptno; - show all employee information, and information from department members of the 10 Department -- error Select, e.*, d.* From, EMP, e, Dept, D Where, e.deptno=d.deptno, and, e.deptno = 10; - correct Select, e.*, d.* From, EMP, e, Dept, D Where, e.deptno=d.deptno (+), and, d.deptno (+) =10; - Select, e.*, d.* From, EMP, e, Dept, D Where, e.deptno = d.deptno (+), and, d.deptno (+) = 10; - outer join symbol (+) * Use (+) external symbols to note: 1- can only appear after the where clause (otherwise it will compile a compile error) 2- if the where clause has more than one condition, each condition must use