Relational Operator - Join

About

Notation

Relational

<MATH> \LARGE R_1 \bowtie_c R_2 </MATH> where:

SQL

Symbol

Type Symbol Unicode Point Latex
Join <math>\Join</math> 2A1D \Join
Left Outer Join 27D5 \leftouterjoin
Right Outer Join 27D6 \rightouterjoin
Full Outer Join 27D7 \fullouterjoin

Rule

<MATH> \LARGE R_1 \bowtie_{ predicate } R_2 = \sigma_{ predicate } ( R_1 \times R_2 ) </MATH> which means:

is the same than

Type

Logical

Short hand:

Implementation


Powered by ComboStrap