Question: what is the difference between inner join and self 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. ... By the way, If you have written INNER join using where clause than using comparison operator as = will be known as an equijoin.