IntermediateJOINs (INNER, LEFT, RIGHT, FULL)

CROSS JOIN: all employee-project combinations

The query

SQL

SELECT
  e.first_name,
  e.last_name,
  p.name AS project
FROM employees e
CROSS JOIN projects p
LIMIT 50;

Tested against PostgreSQL 16

Note

“CROSS JOIN produces a Cartesian product (all combinations). M*N rows result. Use carefully!