Difference between revisions of "Type of Joins ansi and Oracle"
Jump to navigation
Jump to search
(Created page with "Ansi * Cross Join * Natural Join (equijoin) * Join Using (col, col); * Join ON () eg x=y Oracle * Cartesian Product") |
|||
Line 1: | Line 1: | ||
Ansi | Ansi | ||
* Cross Join | * Cross Join | ||
* Natural Join (equijoin) | * Natural Join (equijoin) join on all common columns | ||
* Join Using (col, col); | * Join Using (col, col); join on common columns but column is specified | ||
* Join ON () eg x=y | * Join ON () eg x=y | ||
Oracle | Oracle | ||
* Cartesian Product | * Cartesian Product |
Revision as of 22:54, 25 October 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
- Cartesian Product