Difference between revisions of "Type of Joins ansi and Oracle"
Jump to navigation
Jump to search
Line 9: | Line 9: | ||
* Equijoin -> Natural Join, Join Using Clause, Join On (if the ewuality operator is used) | * Equijoin -> Natural Join, Join Using Clause, Join On (if the ewuality operator is used) | ||
* Non-Equijoin - > ON Clause | * Non-Equijoin - > ON Clause | ||
Oracle Syntax Uses the Join condition in the WHERE clause | |||
SELECT table1.column, table2.column | |||
FROM table1, table2 | |||
WHERE table1.column1 = table2.column2 |
Latest revision as of 20:37, 1 November 2017
Ansi
- Cross Join
- Natural Join (equijoin) join on all common columns
- Join Using (col, col); join on common columns but column is specified
- Join ON () eg x=y
Oracle -> ANSI
- Cartesian Product -> Cross Join
- Equijoin -> Natural Join, Join Using Clause, Join On (if the ewuality operator is used)
- Non-Equijoin - > ON Clause
Oracle Syntax Uses the Join condition in the WHERE clause
SELECT table1.column, table2.column FROM table1, table2 WHERE table1.column1 = table2.column2