Join (relational algebra)

In relational algebra, a join is a binary operation, written as ${\displaystyle R\bowtie S}$ where ${\displaystyle R}$ and ${\displaystyle S}$ represent relations, that combines their data where they have a common attribute.