Cross join

sql

SELECT c.color, s.size
FROM colors c
CROSS JOIN sizes s;

Explanation

Cross joins multiply rows, so use them deliberately.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Joins

Return rows with matches in both tables.

Open In sheetsqlsame section

Keep all rows from the left table and match rows from the right table.

Open In sheetsqlsame section

Keep all rows from the right table.

Open In sheetsqlsame section

Return matched and unmatched rows from both tables.

Open In sheetsqlsame section

Join a table to itself.

Open In sheetsqlsame section

Return all columns from a table.