lectures.alex.balgavy.eu

Lecture notes from university.
git clone git://git.alex.balgavy.eu/lectures.alex.balgavy.eu.git
Log | Files | Refs | Submodules

joins.md (417B)

      1 +++
      2 title = "Joins"
      3 +++
      4 
      5 # Joins
      6 
      7 Types:
      8 
      9 -   `[INNER] JOIN`: usual join, eliminates tuples without a partner
     10 -   `LEFT JOIN`: preserves rows of left table
     11 -   `RIGHT JOIN`: preserves rows of right table
     12 -   `FULL JOIN`: preserves rows of both tables
     13 -   `CROSS JOIN`: Cartesian product in all combinations
     14 
     15 Join predicates:
     16 
     17 -   NATURAL: yields comparison of columns with same name
     18 -   USING (A1, \..., An) appended