Produto cartesiano |
O produto cartesiano entre dois conjuntos é um terceiro conjunto constituído por todos os elementos do primeiro combinados com todos os elementos do segundo.
Os comandos abaixo geram o produto cartesiado entre as tabelas EMP e DEP:
Sintaxe antiga | SQL99 |
---|---|
SELECT emp.empno, emp.ename, emp.deptno, dept.deptno, dept.dname FROM emp, dept; |
SELECT emp.empno, emp.ename, emp.deptno, dept.deptno, dept.dname FROM emp CROSS JOIN dept; |
EMPNO ENAME DEPTNO DEPTNO DNAME ---------------------- ---------- ---------------------- ---------------------- -------------- 7369 SMITH 20 10 ACCOUNTING 7499 ALLEN 30 10 ACCOUNTING 7521 WARD 30 10 ACCOUNTING 7566 JONES 20 10 ACCOUNTING 7654 MARTIN 30 10 ACCOUNTING 7698 BLAKE 30 10 ACCOUNTING 7782 CLARK 10 10 ACCOUNTING 7788 SCOTT 20 10 ACCOUNTING 7839 KING 10 10 ACCOUNTING 7844 TURNER 30 10 ACCOUNTING 7876 ADAMS 20 10 ACCOUNTING 7900 JAMES 30 10 ACCOUNTING 7902 FORD 20 10 ACCOUNTING 7934 MILLER 10 10 ACCOUNTING 7369 SMITH 20 20 RESEARCH 7499 ALLEN 30 20 RESEARCH 7521 WARD 30 20 RESEARCH 7566 JONES 20 20 RESEARCH 7654 MARTIN 30 20 RESEARCH 7698 BLAKE 30 20 RESEARCH 7782 CLARK 10 20 RESEARCH 7788 SCOTT 20 20 RESEARCH 7839 KING 10 20 RESEARCH 7844 TURNER 30 20 RESEARCH 7876 ADAMS 20 20 RESEARCH 7900 JAMES 30 20 RESEARCH 7902 FORD 20 20 RESEARCH 7934 MILLER 10 20 RESEARCH 7369 SMITH 20 30 SALES 7499 ALLEN 30 30 SALES 7521 WARD 30 30 SALES 7566 JONES 20 30 SALES 7654 MARTIN 30 30 SALES 7698 BLAKE 30 30 SALES 7782 CLARK 10 30 SALES 7788 SCOTT 20 30 SALES 7839 KING 10 30 SALES 7844 TURNER 30 30 SALES 7876 ADAMS 20 30 SALES 7900 JAMES 30 30 SALES 7902 FORD 20 30 SALES 7934 MILLER 10 30 SALES 7369 SMITH 20 40 OPERATIONS 7499 ALLEN 30 40 OPERATIONS 7521 WARD 30 40 OPERATIONS 7566 JONES 20 40 OPERATIONS 7654 MARTIN 30 40 OPERATIONS 7698 BLAKE 30 40 OPERATIONS 7782 CLARK 10 40 OPERATIONS 7788 SCOTT 20 40 OPERATIONS 7839 KING 10 40 OPERATIONS 7844 TURNER 30 40 OPERATIONS 7876 ADAMS 20 40 OPERATIONS 7900 JAMES 30 40 OPERATIONS 7902 FORD 20 40 OPERATIONS 7934 MILLER 10 40 OPERATIONS 56 rows selected |
Realizado por Turtle Learning ®. Última alteração em 2011-02-26