PostgreSQL

PostgreSQL CROSS JOIN

Produce every possible combination of rows from two tables.

Use CROSS JOIN

SELECT p.name, c.name AS category
FROM products AS p
CROSS JOIN categories AS c;

A table with 3 rows crossed with a table with 4 rows produces 12 combinations. Use this intentionally because result size grows quickly.