(INNER) JOIN

- One of the key components of a select statement is the ability to join two or more tables on one or more columns and return columns from those tables. An INNER JOIN or just JOIN in the from clause joins two or more tables and returns rows in the JOIN from those tables only where that value exists in both tables. I'll describe how that works and compare the ANSI syntax to the Oracle specific syntax. Here are the JOIN types you can perform in a select statement in Oracle: An INNER JOIN, also known as JOIN, a LEFT JOIN, also know as LEFT OUTER JOIN, a RIGHT JOIN, also know as RIGHT OUTER JOIN, FULL OUTER JOIN, NATURAL JOIN and CROSS JOIN. I'll review the INNER JOIN in this video. Here are the comparable syntaxes between the ANSI standard and Oracle specific syntax for INNER JOINs both fully supported in Oracle. In each syntax I've highlighted the statements that enable the corresponding syntax. The ANSI syntax does it with INNER JOIN, the inner is optional, and the Oracle syntax just…