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.

Image for post
Image for post
Credit to Lucidchart for helping me create these tables (not sponsored)

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…

Jaquelin Erazo

Data enthusiast by day, multi-fan by night. Continually seeking to learn. Let’s connect: linkedin.com/in/j-erazo/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store