EQUI Join is an special join in which we use only equality operator. In other words in any join query if you use only equal (=) operator than it is an EQUI join. If you use any other operator (<,>..) than it is no more a EQUI Join.
Equi Join
SQL Server EQUI Join: This article is about what is EQUI Join in SQL Server.

