SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join

Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins.

TABLE OF CONTENTS
00:00 - Intro
01:10 - INNER JOIN
04:20 - LEFT JOIN
07:03 - RIGHT JOIN
08:35 - FULL OUTER JOIN
09:36 - Optional OUTER Clause
10:38 - Alias the Join Tables
11:22 - Format SQL Join
11:55 - Filtering SQL Join in WHERE Clause
12:20 - Filter SQL OUTER Join in ON Clause
14:40 - Filter SQL INNER Join in ON Clause
15:30 - RIGHT JOIN can be changed to LEFT JOIN

READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS

YOUTUBE NEWS UPDATES

VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!

SUBSCRIBE TO OUR EMAIL LIST!

LET'S CONNECT!

[joeyblue]

TABLE OF CONTENTS
00:00​ - Intro
01:10​ - INNER JOIN
04:20​ - LEFT JOIN
07:03​ - RIGHT JOIN
08:35​ - FULL OUTER JOIN
09:36​ - Optional OUTER Clause
10:38​ - Alias the Join Tables
11:22​ - Format SQL Join
11:55​ - Filtering SQL Join in WHERE Clause
12:20​ - Filter SQL OUTER Join in ON Clause
14:40​ - Filter SQL INNER Join in ON Clause
15:30​ - RIGHT JOIN can be changed to LEFT JOIN

[momentshub]

Man, I watched like 6-7 video tutorials about Join in SQL. Your is the only one that I understood. Great explanation!

[diamondDog_]

And I thought Joins were advanced concepts in SQL that I'm not yet ready to understand. God bless you Mr. Blue

[PatrickburkeTVComedy]

Great video. The graphic and audio quality made this very easy to learn.

[danieldouglas]

Great video! I got a much better grasp on SQL Joins in 18 minutes than I did in my instructor's 2.5 hour lecture. Thank you, sir!

[bdwcoym]

I love your pacing. Not too fast or too slow. You're right in the goldilocks zone!

[halildurmaz]

Clear tutorial ! I cannot understand why the others make this topic hard to understand :) Especially the tiny tables you use, allows us to clearly observe what is happening

[benjaminswindle]

I just started using SQL yesterday, and I already have a much higher level of understanding than a few of our developers, thanks Joey! Great series of videos!

[JerodimusPrime]

This is the best SQL join explanation I've found on YouTube. Thanks for your concise and understandable tutorial.

[realentropyst]

Spent an hour reading various tutorials and watching videos on this. Then you saved my nerves.
This is by far the best and easiest explanation to SQL Joins I've ever seen, I can't thank you enough!

[vespa]

Thank you so much for this video! I've watched so many PowerPoint presentations and lectures and your video was the only one that actually helped me understand joins! Thanks again

[MrBauer]

Thank you Sir! You have made learning about Joins so simple. I spent hours reading through text books, trying to figure it out, and in less than 20 minutes you succeeded in making it clear to me.

[zzqwnrp]

This is by far the most helpful video I watched about Joins. So simple and straight to the point.

[SS-bore]

This was hands down the best SQL join tutorial I've ever seen in my life! Keep up the good work!

[isaacsmoli]

Congrats, two years later and continuous amazing. I can understand everything with your videos.

[ekaterinaslavova]

Finally a tutorial that made things simple and makes sense! Thank you!

[AmitYadav-hnrn]

Goodness, he is the only man who makes sense when it comes to explaining confusing joins, really good. Thanks

[alexandreabarbosa]

Awesome! Straight to the point! Correct and excellent explanation!

[searez]

As someone has said in the comment section, I have watched several videos to get a good grasp (concept) of the SQL joins, in my opinion this tutorial is the best tutorial I found. Simple, clear and to the point. Many thanks & God bless you!

[georgecristianiordan]

great man we owe you a lot, great explanations, great teacher!!!First I was learning without the app installed and I couldn't understand a thing, then I installed the Microsoft sql and I learned all your tutorials, I even created those tables that you show them in that video alone to understand better... Your are the best! thanks a lot.