Oracle INNER JOIN
Published by : Obay Salah , December 2, 2024
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 Example
Let's take an example to perform Inner Join on two tables "Suppliers" and "Order1".
Suppliers
Order1
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
Comments
no comment yet!