Difference between revisions of "Type of Joins ansi and Oracle"

From rbachwiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
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
 
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
Retrieved from "https://www.r512.com/index.php?title=Type_of_Joins_ansi_and_Oracle&oldid=1076"