Oracle INNER JOIN

Inner Join is the simplest and most common type of join. It is also known as simple join. It returns all rows from multiple tables where the join condition is met.

Syntax

SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;

Image representation of Inner Join

Oracle Inner Join

Oracle INNER JOIN Example

Let's take an example to perform Inner Join on two tables "Suppliers" and "Order1".

Suppliers

Oracle Inner Join

Oracle Inner Join supplier

Order1

Oracle Inner Join

Oracle Inner Join order This example will return all rows from "suppliers" and "order1" table where there is a matching supplier_id value in both the suppliers and order1 tables.

Execute the following query

SELECT suppliers.supplier_id, suppliers.supplier_name, order1.order_number
FROM suppliers
INNER JOIN order1
ON suppliers.supplier_id = order1.supplier_id;

Output

Oracle Inner Join

DATABASE

SQL

VIDEOS

Orcale SQL Tutorial

Inner Join

Oracle INNER JOIN

Oracle INNER JOIN Example