This introductory guide to SQL is soon coming to an end, and you’ll be able to go out and perform analysis for your business using SQL.
But before that, there’s one last important thing to add to your toolbox: combining different tables into one.
This is done with the JOIN
function.
Remember the different ways to control the height and width of tables? The JOIN
function increases the width of the resulting table by adding columns from other tables.
The JOIN
function in SQL can work in a quite advanced way, with many different variations (left, right, inner, outer, etc.).
But the LEFT JOIN
function is by far the most frequently used, so this is the focus in this guide.
Next up
Finding Common Identifiers & Choosing your Primary Table
Joining tables in SQL requires you to have a common identifier between tables A & B. Learn how to find it.
Go to lesson