|
|
| Re: Is Equi Join ANSI Standard [message #12783 is a reply to message #12778] |
Sat, 05 June 2004 13:12  |
 |
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
An equi join can be done in either ANSI standard syntax or non-ANSI standard syntax.
Oracle versions 9i and 10g use ANSI standard joins. Oracle version 8i did not use ANSI standard joins.
In 9i and 10g, an ANSI standard equi join, with or without the optional keyword INNER, would be:
scott@ORA92> SELECT ename, dname
2 FROM emp INNER JOIN dept ON emp.deptno = dept.deptno
3 /
ENAME DNAME
---------- --------------
SMITH RESEARCH
ALLEN SALES
WARD SALES
JONES RESEARCH
MARTIN SALES
BLAKE SALES
CLARK ACCOUNTING
SCOTT RESEARCH
KING ACCOUNTING
TURNER SALES
ADAMS RESEARCH
JAMES SALES
FORD RESEARCH
MILLER ACCOUNTING
14 rows selected.
In Oracle 8i and before, the following non-ANSI standard syntax, which can still be used in Oracle 9i, would be used for an equi join:
scott@ORA92> SELECT ename, dname
2 FROM emp, dept
3 WHERE emp.deptno = dept.deptno
4 /
ENAME DNAME
---------- --------------
SMITH RESEARCH
ALLEN SALES
WARD SALES
JONES RESEARCH
MARTIN SALES
BLAKE SALES
CLARK ACCOUNTING
SCOTT RESEARCH
KING ACCOUNTING
TURNER SALES
ADAMS RESEARCH
JAMES SALES
FORD RESEARCH
MILLER ACCOUNTING
14 rows selected.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
