Section outline

  • Topics Objective

    1. Understand how to join multiple tables using different types of join. 

    Topics Outcomes

    1. Able to solve problem using different types of join. 

    SQL JOIN

    A JOIN clause is used to combine rows from two or more tables, based on a related column between them. 

    Different Types of SQL JOINs

    Here are the different types of the JOINs in SQL:

    • (INNER) JOIN: Returns records that have matching values in both tables
    • LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
    • RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
    • FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table


    SQL INNER JOIN  SQL LEFT JOIN  SQL RIGHT JOIN  SQL FULL OUTER JOIN


    • url icon
      SQL INNER JOIN URL

      The INNER JOIN keyword selects records that have matching values in both tables.

    • url icon
      SQL LEFT JOIN URL

      The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

    • url icon
      SQL RIGHT JOIN URL

      The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side, when there is no match.

    • url icon
      SQL FULL OUTER JOIN URL

      The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records.

      Note: 

      1. FULL OUTER JOIN can potentially return very large result-sets!
      2. FULL OUTER JOIN and FULL JOIN are the same.


    • url icon
      Joins Operation in sql server URL

    • url icon
      Lab Class Content URL
      Students must
      View

      Lab Class Content upto VIEW