What is an equi-join?
An equi-join of two tables is obtained by putting an equality condition on the cartesian product of two tables. It is generally put on a common column which is the primary key of one table and foreign key of another table.