CROSS JOIN
A Cartesian product: every left row is paired with every right row, so the result has rows(left) times rows(right) rows.
SELECT * FROM film CROSS JOIN category;
When to use
PP 03 Q2.1: a query with no ON or USING clause is a CROSS JOIN even if written INNER JOIN, giving 6 x 3 = 18 rows. PP 02 asks for join row counts in the same way.
See PP 02.