Oracle Equi Join | Equi Join - oracle tutorial - sql tutorial
What is Oracle Equi join ?
- Oracle Equi join returns the matching column values of the associated tables.
- It uses a comparison operator in the WHERE clause to refer equality.
- When you relate two tables on the join condition by equating the columns with equal(=) symbol, then it is called an Euqi-Join. Equi-joins are also called as simple joins.
Syntax:
- Equijoin also can be performed by using JOIN keyword followed by ON keyword and then specifying names of the columns along with their associated tables to check equality.
Syntax
Oracle EQUI JOIN Example
- Let' take two tables "agents" and "customer".
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Agent data
Customer table
Customer data
- Execute this query
- SELECT agents.agent_city,customer.last_name,
- customer.first_name
- FROM agents,customer
- WHERE agents.agent_id=customer.customer_id;
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Output:
Oracle Equi Join vs Inner Join
Oracle equi join vs inner join query