CROSS JOIN makes every possible pair

CROSS JOIN pairs every row from the first table with every row from the second. Two breads and two fillings produce four pairs. It has no ON condition because no rows are being matched. Use it deliberately: large tables can create a very large result.

SELECT breads.name AS bread, fillings.name AS filling
FROM breads
CROSS JOIN fillings;