Equality Joins or Inner Joins

Equality Joins is the most commonly used joins. This is also called inner joins and is based upon two (or more) tables having equivalent data stored in a common column. Such joins are called Equality Joins, equijoins, inner joins or simple joins. The following section illustrates how to create joins based upon a common column containing equivalent data stored in multiple tables.