1. Database Join

    1. Database Join Important Terms

      1. Foreign Key

      2. Aliases Names

    2. Database Join Types

      1. (INNER) JOIN

      2. (OUTER) JOIN

        1. FULL (OUTER) JOIN

        2. LEFT (OUTER) JOIN

        3. RIGHT (OUTER) JOIN

      3. The CARTESIAN JOIN or CROSS JOIN

    3. A Full Example that Explain all Types of Join

  2.  Summary

Material File