Glossary: SQL Beyond the Basics
CROSS JOIN
Pairs every row of one table with every row of another. Three months and 11 products give a 33-row grid you can LEFT JOIN sales onto.
Glossary: SQL Beyond the Basics
Pairs every row of one table with every row of another. Three months and 11 products give a 33-row grid you can LEFT JOIN sales onto.