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

DATABASE

SQL

VIDEOS

Orcale SQL Tutorial

Equi Join

Oracle EQUI JOIN

Oracle EQUI JOIN Example