Javatpoint Logo
Javatpoint Logo

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

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".

Agents table

Oracle Equi Join

Agent data

Oracle Equi Join 2

Customer table

Oracle Equi Join 3

Customer data

Oracle Equi Join 4

Execute this query

Output

Oracle Equi Join 5
Next TopicOracle SELF JOIN




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA