What is difference between Inner vs Self vs Cross?

Inner Join: Inner Join can also be called the simple join. It allows the coder to filter the outcomes of the cartesian product by some predicate.

Self Join: It is used to join one single table with itself as there were two different tables.

Cross Join: This is the basic join, it is nothing but a cartesian product. This join method compares every single row of a table with every single row of the other table.