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:
tablename1: The table name from which you want to fetch records.
col1: The column or field name that will be return.
In the above example, we are retriving matching rows from associated table using