Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

SQL Joins: A Guide and Examples

Database Star

📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=UfgRTbRN9FM

🎓 Learn and become confident with SQL joins: https://databasestar.mykajabi.com/joins-mastery/?video=UfgRTbRN9FM

SQL joins are a commonly used feature when writing queries. They let you combine two (or more) tables together in your SQL query and see a single set of results.

In this video, you'll learn a bit more about what SQL joins are, why they are needed, the different types of joins, and examples of each in a SELECT query.

I'll also share a few tips on working with joins and things to avoid.

Related videos:

How to Join 3 Tables: https://www.youtube.com/watch?v=TGt2xa7EzvI

Self Joins: https://www.youtube.com/watch?v=7T8b7g7aV1A

Timestamps:

00:00 Start

00:16 What is a join?

00:48 Sample tables

01:38 Start of query

01:58 Inner Join

04:49 Left Outer Join

06:10 Right Outer Join

07:10 Full Outer Join

07:38 Joins are not bad

08:16 Using keyword

08:46 Natural Join

09:17 Joins in a Where clause

SQL Joins: A Guide and Examples | Knoovi