SQL-DataCamp-Joining Data in SQL

1. Introduction to Joins

1.1 Introduction to INNER JOIN (video)

1.2 INNER JOIN

PostgreSQL was mentioned in the slides but you’ll find that these joins and the material here applies to different forms of SQL as well.

Recall from the video the basic syntax for an INNER JOIN, here including all columns in both tables:

SELECT *
FROM left_table
INNER JOIN right_table
ON left_table.id = right_table.id;