EQUIJOIN (Relational Operation)

The most common use of join involves join conditions with equality comparisons only, in this case, it is called an EQUIJOIN.

In the result of an EQUIJOIN, we have one or more pairs of attributes that have identical values in the tuple.

$$DEPT\_MGR\leftarrow DEPARTMENT{\bowtie }_{MGRSSN=SSN}EMPLOYEE$$