Relational Operator - Join

1 - About

3 - Notation

3.1 - Relational

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

3.2 - SQL

3.3 - 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

4 - Rule

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

is the same than

5 - Type

5.1 - Logical

Short hand:

5.2 - Implementation


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap