Question: what is the difference between inner join and cross join?
Answer: A cross join matches all rows in one table to all rows in another table. An inner join matches on a field or fields. ... The cross join will have 100 rows returned and they won't be related, just what is called a Cartesian product. The inner join will match records to each other.