ORACLE
ORACLE JOINS
INNER JOIN
OUTER JOIN
EQUI JOIN
SELF JOIN
CROSS JOIN
ANTI JOIN
SEMI JOIN
ORACLE TUTORIAL
Oracle Introduction
What Is Oracle
ORACLE TABLES
Create Tables
Create Table As
Alter Table
Drop Table
Global Temorary Tables
Local Temorary Tables
ORACLE VIEWS
Create View
ORACLE QUERIES
SELECT
INSERT
INSERT ALL
UPDATE
DELETE
TRUNCATE TABLE
ORACLE CLAUSES
DISTINCT
FROM
ORDER BY
GROUP BY
HAVING
ORACLE OPERATORS
UNION
UNION ALL
INTERSECT
MINUS
ORACLE ADVANCE
PROCEDURES
FUNCTION
CURSOR
TRIGGER

INNER JOIN



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;   

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


Suppliers :
SUPPLIER_IDSUPPLIER_NAMESUPPLIER_ADDRESS
1Reebok shoesrajiv nagar
2USPA ShirtsUllas nagar
3KingfisherSriram colony

Orders :
ORDER_NUMBERSUPPLIER_IDCITY
1011Hyderabad
1022Mumbai

This example will return all rows from "suppliers" and "orders" table where there is a matching supplier_id value in both the suppliers and orders tables.


Execute the following query :
SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_number  
FROM suppliers   
INNER JOIN orders  
ON suppliers.supplier_id = orders.supplier_id;  

Output :
SUPPLIER_IDSUPPLIER_NAMEORDER_NUMBER
1Reebok Shoes101
2USPA Shirts102


What Is Oracle

What Is Oracle

posted on 2019-11-29 01:11:21 - ORACLE Tutorials


TRIGGER

ORACLE - Trigger

posted on 2019-11-28 22:14:22 - ORACLE Tutorials


CURSOR

ORACLE - Cursor

posted on 2019-11-28 22:13:54 - ORACLE Tutorials


MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials