1.3.11. Join types (inner and outer)

  • Inner joins
    • not the only joins
    • eliminate tuples without a matching counterpart
    • i.e. tuples with a null value for the join attribute are discarded

Relational Inner join demonstration