What is the difference between cross join and inner join?

Question

MySQL

What is the difference between a cross join and an inner join if a cross join with a (where) condition gives the same result as an inner one?

Answer 1

https://dev.mysql.com/doc/refman/5.7/en/join.html

In MySQL, JOIN, CROSS JOIN, and INNER JOIN are syntactic equivalents (they can replace each other).

Answer 2

There are only 3 types:

• Outer Left
  
• External law
  
• All the rest are synonyms.