Type of Joins ansi and Oracle

From rbachwiki
Revision as of 22:54, 25 October 2017 by Bacchas (talk | contribs)
Jump to navigation Jump to search

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
Retrieved from "https://www.r512.com/index.php?title=Type_of_Joins_ansi_and_Oracle&oldid=1036"