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.

Syntax

SELECT column_list   

FROM table1, table2....  

WHERE table1.column_name =  

table2.column_name;

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

 SELECT *  

FROM table1   

JOIN table2  

[ON (join_condition)] 

Oracle EQUI JOIN Example

Let’ take two tables “agents” and “customer”.

Agents table

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;   

Output