Question: what is the difference between self join and inner join?
Answer: Difference between Self and Equi Join in SQL - INNER Join example MySQL. The main difference between Self Join and Equi Join is that In Self Join we join one table to itself rather than joining two tables. ... Any INNER Join with equal as join predicate is known as Equi Join.