Oracle / PLSQL Joins
There are 4 different types of Oracle joins:
•Oracle INNER JOIN (or sometimes called simple join)
•Oracle LEFT OUTER JOIN (or sometimes called LEFT JOIN)
•Oracle RIGHT OUTER JOIN (or sometimes called RIGHT JOIN)
•Oracle FULL OUTER JOIN (or sometimes called FULL JOIN)
INNER JOIN (simple join)
Than returns multiple table matching (duplicates) data on a single output. •
Inner join Syntax
The syntax for the INNER JOIN in Oracle/PLSQL is:
SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
Visual Illustration
LEFT OUTER JOIN
Return all data from left table with matching data for other table.
Syntax
The syntax for the Oracle LEFT OUTER JOIN is:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
Visual Illustration
RIGHT OUTER JOIN
Return all data from right table whit matching data from other table.
Syntax
The syntax for the Oracle RIGHT OUTER JOIN is:
SELECT columns
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
Visual Illustration
FULL OUTER JOIN
Return all data from left and right.
Syntax
The syntax for the Oracle FULL OUTER JOIN is:
SELECT columns
FROM table1
FULL [OUTER] JOIN table2
ON table1.column = table2.column;
Visual Illustration
