Oracle Inner join | Inner Join - oracle tutorial - sql tutorial
![Oracle inner join](https://www.wikitechy.com/tutorials/oracle/img/oracle-images/oracle-inner-join.gif)
Learn oracle - oracle tutorial - Oracle inner join - oracle examples - oracle programs
What is Oracle INNER JOINS ?
- Oracle JOINS are used to retrieve data from multiple tables.
- Oracle INNER JOINS return all rows from multiple tables where the join condition is met.
- Oracle INNER JOIN (or sometimes called simple join).
![inner join](https://www.wikitechy.com/tutorials/oracle/img\oracle-images\inner-join.gif)
Syntax:
SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
click below button to copy the code. By - oracle tutorial - team
Example:
SELECT wikitechy_employee.id, wikitechy_employee.name, orders.orderid
FROM wikitechy_employee
INNER JOIN orders
ON wikitechy_employee.id = orders.id;
click below button to copy the code. By - oracle tutorial - team
Sample Database:
- We have a table called wikitechy_employee with four fields (id, name, position, and city). It contains the following data:
![employee table database](https://www.wikitechy.com/tutorials/oracle/img\oracle-images\sample-database-employee.png)
- We have another table called orders with three fields (id, customer_name, and orderid).
![customer table database](https://www.wikitechy.com/tutorials/oracle/img\oracle-images\customer-table.png)
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
INNER JOIN:
![inner join command](https://www.wikitechy.com/tutorials/oracle/img\oracle-images\inner-join-command.png)
- INNER JOIN example would return all rows from the wikitechy_employee and orders tables where there is a matching Id value in both the wikitechy_employee and orders tables.
- The rows of Indhu and Vinoth is displayed from the table since the id 333, 117 does exist in both the tables.
Oracle ALL Joins
![Oracle join query](https://www.wikitechy.com/tutorials/oracle/img\oracle-images\sql-joins-all.gif)
Oracle Join Query - Inner Join Query - Left Outer Join Query - Right Outer Join Query - Full Outer Join Query