What is a cross join and how does it differ from an inner join?

Question Explain

This question checks understanding of Cartesian products versus filtered combinations.