MySQL SQL
MySQL CROSS JOIN
Return every combination of two tables.
SELECT p.name, c.name
FROM products p
CROSS JOIN categories c;A CROSS JOIN can produce a very large result, so use it intentionally.
MySQL SQL
Return every combination of two tables.
SELECT p.name, c.name
FROM products p
CROSS JOIN categories c;A CROSS JOIN can produce a very large result, so use it intentionally.