CROSS JOIN

sql

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

Explanation

Use carefully. Output size becomes `left_rows × right_rows`.

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 Join types at a glance

Return only rows that match on both sides.

Open In sheetsqlsame section

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

Open In sheetsqlsame section

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

Open In sheetsqlsame section

Keep all rows from both tables and match where possible.

Open In sheetsqlsame section

Prefer primary keys and foreign keys over names or free-form text.

A `WHERE` clause can accidentally turn a left join into an inner join.