# CROSS JOIN

A join returning every possible pairing of rows from two table expressions.

## What is **CROSS JOIN** in a relational database?

**CROSS JOIN** — A join returning every possible pairing of rows from two table expressions.

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

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

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/cross-join