what is the difference between cross join and inner join?
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.