Type of Joins ansi and Oracle

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