1.3.12. Outer joins

  • Outer joins control what's discarded
    • Keep unmatched tuples in either
      • Left, right, or both relations
      • Left, right of full outer join correspondingly

    Relational demonstration of Outer joins