Relational Operator - Equi-joins

Relational Algebra Between Sql And Query Plan


An Equi-join is a join where the condition (predicate) is an equality.

All other join operations with a predicate other than equality are called theta join


An equi-join links two relations (tables, …) on common values in a column in relation 1 with a column in relation 2.


The restriction conforms to the following syntax when the condition is specified:

  • Relational Syntax

<MATH> \LARGE R \bowtie_{R.A = S.A} S </MATH>

  • SQL
Table1.column_a = Table2.column_a


A natural join is a shorthand equi-join where the equality applied to all shared attributes.

<MATH> \LARGE R \bowtie_{attrs(R) \cap attrs(S)} S </MATH> where:

  • <math>attrs(R) \cap attrs(S)</math> is the intersection of the attributes of R and S.

See SQL - Natural Join


<MATH> \LARGE R_1 \bowtie_{ a = b } R_2 = \sigma_{a=b} ( R_1 \times R_2 ) </MATH>

The join of R1 and R2 on A=B is the same that the selection of the cross product of R1 and R2 where A=B.


Sql Notation

See this article : SQL - (Equi|Simple|Inner|Natural) Join

Discover More
Bobj Equi Join
Equi-joins in BOBJ

in Bobj. You have two equi-join types in : the simple the complex (This is a single join that links multiple columns between two tables. ) You can create a complex equi-join. This is a single...
Theta Join
Relational Algebra - Theta-join

A theta-join is a difficult/complex join where the condition is not a equality. Example: Band join or range join. A theta is a join that links tables based on a relationship other than the equality...
Relational Algebra Between Sql And Query Plan
Relational Operator - Join

join is a relational operator that pair tuples (row) of two relations (table, ...) according to a condition (predicate). where: c is a condition (ie predicate) See Type Symbol Unicode...
SQL - (Equi|Simple|Inner|Natural) Join

in SQL An equi-join also known as simple join link relation (tables, ...) based on the equality between the values in the column of one relation (table, ...) and the values in the column of another. Because...

Share this page:
Follow us:
Task Runner