What is a CROSS JOIN?
Model answer
It returns every combination of rows from the two tables (the Cartesian product). It is useful for generating combinations, such as sizes and colours, but an accidental missing join condition creates a huge result.
Learn this topic
SQL JOINs: INNER JOIN and LEFT JOIN Explained in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.
More questions
- What is a join, and what types are there?
- What is the difference between INNER JOIN and LEFT JOIN?
- How do you find rows in one table that have no match in another?
- What is a self join?
- Why does a missing join condition create duplicate or huge results?
- What is the difference between putting a condition in ON and in WHERE for a LEFT JOIN?