Different Types of SQL Joins: Concepts and Step-by-Step Thought Process

If you’re a beginner SQL-er and confused about the different joins — look no further! I’ll help you distinguish each join and what they do. We’ll look into the fundamental concepts as well as how to write the syntax. Let’s begin!

First off, let’s create a hypothetical situation and imagine a database for an online store. There are three different tables: customers, orders, and products.

As you can see from the visual above, each table contains specific information. The customers table contains information about the customers, the orders table about orders, and the products table about the products.

Here’s a…