SQL JOINS

Stephanie Warner headshot
Stephanie Warner|March 16, 2020
sql join
sql join
Sections
    No Data

    The JOIN clause is used to join two or more tables together based on a matching column between the tables. The result set combines records from each table based on the matching column. The column(s) used to join tables together are typically referred to as ‘Primary’ or ‘Foreign’ keys.

    There are four major types of joins used in SQL syntax:

    ‘INNER’ and ‘OUTER’ keywords in the JOIN clauses are optional and not required in the syntax.

    (INNER) JOIN

    image1

    LEFT JOIN

    unnamed

    RIGHT JOIN

    image4

    FULL (OUTER) JOIN

    image4

    This blog post is part of our SQL series:

    Stephanie Warner headshot
    Stephanie Warner

    Stephanie is a big time math nerd, avid snowboarder, and overall winter lover. She enjoys the torture of running and traveling to work Ragnar Relay races. From shredding the gnar to getting far too invested in murder/crime documentaries, you'll also find her petting all the doggos. She was an employee of PDQ.

    Related articles