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") |
|||
(2 intermediate revisions by the same user not shown) | |||
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 -> 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 | |||
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