Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle EQUI JOIN

In Oracle, EQUI JOIN is used retrive matching column values of the associated tables. It uses a comparison operator in the WHERE clause to refer equality.

Oracle EQUI JOIN Syntax

To retrive matching column values of the associated tables, use the following syntax:

Syntax

SELECT col1, col2,....
FROM tablename1 A, tablename1 B
WHERE A.column_name = B.column_name; 

Parameters:

tablename1: The table name from which you want to fetch records.

col1: The column or field name that will be return.

Oracle EQUI JOIN example

The following Oracle, retrive matching column values of the associated tables using EQUI JOIN:

Example

SELECT A.firstName, A.lastName, B.firstName, B.lastName
FROM tblCustomerLoan A, tblCustomer B
WHERE A.firstName = B.firstName;

Note:

In the above example, we are retriving matching rows from associated table using EQUI JOIN.