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.
To retrive matching column values of the associated tables, use the following syntax:
Parameters:
tablename1: The table name from which you want to fetch records.
col1: The column or field name that will be return.
EQUI JOIN
:
Note:
In the above example, we are retriving matching rows from associated table using EQUI JOIN
.