Table of Contents

About

The cartesian product is a set operator between two set A and B that produces a set of all pairs (a, b) where:

  • <math>a \in A</math> (ie a in A)
  • and <math>b \in B</math> (ie b in B)

Notation

<MATH>\Large A \times B</MATH>

Example

A = {1, 2} 
B = {a, b}
A x B = {(1,a), (1,b), ((1,c), (2,a), (2,b), (2,c)}

Implementation

Sql

See SQL - Cross Join / Cartesian Product / Cross Product

Relational Algebra

See Relational Operator - Cross Product