Question: what is difference between self join and inner join?
Answer: 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. Both Self Join and Equi Join are types of INNER Join in SQL, but there is the subtle difference between two. Any INNER Join with equal as join predicate is known as Equi Join.