# Cartesian Product

The relation containing every possible concatenation of a tuple from each input relation.

## What is **Cartesian Product** in a relational database?

**Cartesian Product** — The relation containing every possible concatenation of a tuple from each input relation.

```sql
SELECT size.name, color.name
FROM size
CROSS JOIN color;
```

Level: Master · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/master)

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/cartesian-product