Difference between revisions of "Type of Joins ansi and Oracle"
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
* Join ON () eg x=y | * Join ON () eg x=y | ||
Oracle | Oracle -> ANSI | ||
* Cartesian Product | * Cartesian Product -> Cross Join | ||
* Equijoin -> Natural Join, Join Using Clause, Join On (if the ewuality operator is used) | |||
* Non-Equijoin - > ON Clause |
Revision as of 20:29, 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