Uploaded March 2024 | Updated November 2026, 1 hour ago
Left, right, inner, outer, anti, no matter what you call them, Joins are an important part of the SQL for data analysis. In this comprehensive video, learn how to create your first join and more with easy, clear and relevant explanation of the concepts.
๐ป Get the data:
==============
Visit chandoo.org/wp/learn-sql-for-data-analysis to get the dataset. Use the instructions on that page to set up the data in SQL Server or MySQL.
Topics covered in this video:
=======================
Why we need joins in the first place?
Joins explained visually
Join with a one table
Join with two tables
Joins and where clauses
Join and group by
Solving complex business questions using join and CTE
โฑ Video Chapters:
================
0:00 - What is a join and why we need them?
2:22 - Our first join in SQL
3:58 - Join Example #2 - Shipments by name & team
4:56 - Example #3 - Joins with where clause
5:51 - Example #4 - another Join with where clause
6:28 - Using where vs writing the condition in the join itself (#5)
7:22 - Using 3 tables in a join - Example #6
9:24 - Bonus tip with joins
9:52 - Joins and Grouping example (#7)
12:51 - Left, Right and Anti joins explained
14:30 - Left join example (#8)
17:29 - Anti join example (#9)
19:24 - A complex join example with real business problem
~
๐ก Learn more SQL
===============
SQL for beginners: youtu.be/yfWcZ6eot4g
SQL Beginner to PRO video: youtu.be/l8DCPaHc5TQ
Using SQL with Power BI: youtu.be/UQJAHUUFK-o
50 Example SQL Queries - chandoo.org/wp/learn-sql-for-data-analysis
๐ SQL Alternatives:
=================
Using Power Query: youtu.be/UAFExySaSPY
Using Pandas: youtu.be/mkYBJwX_dMs
~
#SQL #joins
Left, right, inner, outer, anti, no matter what you call them, Joins are an important part of the SQL for data analysis. In this comprehensive video, learn how to create your first join and more with easy, clear and relevant explanation of the concepts.
๐ป Get the data:
==============
Visit chandoo.org/wp/learn-sql-for-data-analysis to get the dataset. Use the instructions on that page to set up the data in SQL Server or MySQL.
Topics covered in this video:
=======================
Why we need joins in the first place?
Joins explained visually
Join with a one table
Join with two tables
Joins and where clauses
Join and group by
Solving complex business questions using join and CTE
โฑ Video Chapters:
================
0:00 - What is a join and why we need them?
2:22 - Our first join in SQL
3:58 - Join Example #2 - Shipments by name & team
4:56 - Example #3 - Joins with where clause
5:51 - Example #4 - another Join with where clause
6:28 - Using where vs writing the condition in the join itself (#5)
7:22 - Using 3 tables in a join - Example #6
9:24 - Bonus tip with joins
9:52 - Joins and Grouping example (#7)
12:51 - Left, Right and Anti joins explained
14:30 - Left join example (#8)
17:29 - Anti join example (#9)
19:24 - A complex join example with real business problem
~
๐ก Learn more SQL
===============
SQL for beginners: youtu.be/yfWcZ6eot4g
SQL Beginner to PRO video: youtu.be/l8DCPaHc5TQ
Using SQL with Power BI: youtu.be/UQJAHUUFK-o
50 Example SQL Queries - chandoo.org/wp/learn-sql-for-data-analysis
๐ SQL Alternatives:
=================
Using Power Query: youtu.be/UAFExySaSPY
Using Pandas: youtu.be/mkYBJwX_dMs
~
#SQL #joins


![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)




