Oracle INNER JOIN
Inner Join is the first and most common type of join. The INNER JOIN keyword selects records that have matching values in both or among tables.
Syntax
SELECT column_list
FROM table1
INNER JOIN table2
ON (conditions);
Let’s examine the statement above in detail:
- First, specify the main table in the FROM clause, table1 in this case.
- Second, specify the joined table in the INNER JOIN clause followed by a conditions. The joined table is Table2 in the above statement.
- Third, It returns all rows from multiple tables where the join condition is met.
JOIN more than Two Tables
The following SQL statement selects all orders with customer and shipper information:
Syntax
SELECT column_list
FROM table1
INNER JOIN table2 ON (conditions_1)
INNER JOIN table3 ON (conditions_2)
INNER JOIN table4 ON (conditions_3)
