HomeНаука и техникаRelated VideosMore From: Joey Blue

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

3273 ratings | 214080 views
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. READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Html code for embedding videos on your blog
Text Comments (230)
Venkat NJn (10 hours ago)
Short and sweet
SYAMIL - (23 hours ago)
awesome tutorial
sam shouman (2 days ago)
Man believe me if it weren't for you I would be 0 in sql😂❤
Christopher Jones (3 days ago)
Excellent Video. Where were you at when I was in college?
Saad Malik (5 days ago)
very good mate
Moustapha sarr (7 days ago)
40 minutes before my exams, you saved me ! Thanks !
CJ Wright (7 days ago)
Thank you so much for this video, Joey! The way my professor explained this was awful, and you made it way easier to understand.
CraigSome (14 days ago)
extremely helpful with my exams thank you sir
Eddy Momot (16 days ago)
Amazing set of Videos! Thank you so much!
ABHIJEET SINGH (19 days ago)
i would recommend this channel to everybody.
Grumbo991 (20 days ago)
I barely comment on tutorials but this was TERRIFIC ! Thankyou
Elly Jessy (20 days ago)
I'm now more confident after watching your videos. Great teacher indeed.
firefist206 (20 days ago)
Thanks man. I really appreciate it.
Kalyan S (21 days ago)
MM good video
Andy B (21 days ago)
My tutor took us through a one hour lecture on joins and a one hour classroom session and all that she did was confuse me hugely and make my head spin! You made this so simple and easy to understand. Thanks :-).
EduPark Krupesh (26 days ago)
Special Salute. I went on with google for hours. In just 8 minutes you cleared all messed up things!!. Great Job. Thank you.
Sufyan Ahmed (28 days ago)
Amazing Explanation Mr. Joey
S Ruby (29 days ago)
Very thorough explanation thank you!
Matheus Silitonga (1 month ago)
What was the DBMS you used on this video? Btw, great explanation, Mr. Joey!
uufd rs (1 month ago)
Very well explained, thank you so so much!
A I. (1 month ago)
Amazing 💯 thank you 🙏🏽
Rufino Salgado (1 month ago)
The clearest description of joins I've ever seen.
イリヤ8787 (1 month ago)
god. this helped me so much on my assignment. I was looking at numerous videos and i couldn't understand any of those until i see yours. I'm so glad that this video exists. thank you so much.
Delius v.d Berg (1 month ago)
this really helped me a lot. thank you very much.
singhpad1 (1 month ago)
Thank you for your in-depth explanation for novices like me. Really appreciate it.
Niko Mitrović (1 month ago)
Perfectly explained!
Carl (1 month ago)
Thanks, Joey. That helped a lot.
Pam Taylor (1 month ago)
Thanks Joey for this clear and concise tutorial.  I learned basic concept of SQL
Hanna me (1 month ago)
Thank you. excellent explanation.
Gabriel Weinbeer (1 month ago)
Easy to understand, thats how I like it. Thanks brotha!!!
Fernando Domingos (1 month ago)
Awesome explanation! Thanks. What is this database software are you using btw?
Eric Ellis (1 month ago)
The software shown in the video is SQL Server Managment Studio; the database engine is Microsoft SQL Server 2016.
Nuf (1 month ago)
Exellent video, great explanation. Thank you.
Shad0wB0X3r (1 month ago)
Your vid is amazing! I never understood joins Until ur vid taught me how to do so
Vishal (2 months ago)
Best video on joins.
Daniel Yin (2 months ago)
very clear, thanks a lot
Tristan Izlar (2 months ago)
Great video, cleared up some confusion for me. Subscribed!
Vince Powe (2 months ago)
Read 1-2 paragraphs from 3 different books in 2 mo. on joins. Today I said I'm going to get it. I come home, 18 min later, I'm good. Locked in. THANK-YOU-MR.-BLUE!
Jason Zhao (2 months ago)
Lmao, the picture from the begininng is good enough. Thanks! (First comment ever in youtube )
Osman Khaled (2 months ago)
Great Video with excellent simplified explanation
YANIV SODAI (2 months ago)
when i join 2 table do i limit in the row? or i can join many rows (as long as they fit)?
Fred Trentini (2 months ago)
SQL doesn't have any row limit by default, which means those JOIN clauses simply select everything that matches the given statement. If you wish to put a limit to the amount of selected rows, use the LIMIT clause.
JerodimusPrime (2 months ago)
This is the best SQL join explanation I've found on YouTube. Thanks for your concise and understandable tutorial.
Yegorich (2 months ago)
You are brilliant sir! I understood the concept of inner join as soon as your wrote your fist query. Thanks a lot !
Marco Quaglia Faccio (2 months ago)
Super explanation. Thanks.
Random Ness (2 months ago)
Finally, I get it! Thank you, so simple now.
anthony tamburro (2 months ago)
I'm watching this right now at 2am and the thing I don't understand is the filtering in Joins 11.23 its probably because I dont understand the alias when I read it. but I love your pie graphs great work!
Random Ness (2 months ago)
It makes specifying the tables easier, in shorthand.
Awesome! Straight to the point! Correct and excellent explanation!
Cristian Malai (2 months ago)
Thank you a lot for this awesome tutorial!
Sricharan Reddy (2 months ago)
Very clear explanation. Thank you!!!
Allgunnerpro (2 months ago)
What software is he using?
boon boon (2 months ago)
If I'm joining three tables, how i going to distinguish left and right join?
Dani ! (2 months ago)
+boon boon yes so the temporary table will be the left table
boon boon (2 months ago)
+Dani ! Thanks for your reply
Dani ! (2 months ago)
after you join the first two then they create new temporary table with the join result then you can join the temporary table with the third table. that temporary table is ideal (meaning you are not going to see it).
Nataliia Iatsenko (2 months ago)
Thanks a lot
Arlene FVivaldi (2 months ago)
Jesus, Thank You! I've used so many different sources and No one made it as straight forward as did you. Thank you :-)
Greg B (3 months ago)
Very Clear  - Thank-you!
Abdulhameed bin Hasan (3 months ago)
Thank You.... Great Tute...
Thierry Coton (3 months ago)
Great video, there is just one video missing in your series: Group By, how does it work?
Muhammad Asim (3 months ago)
10 Years of using Excel... Well Versed in using DAX... but never understood SQL Joins.... But this video changed it all... Thanks Joey... May Allah Bless you.... would love if you could start a DAX Series as well.... Thanks in advance....
Łukasz Jerzy Jerzy (3 months ago)
Jezus Christ that was such a magnificently useful video. Thank you.
Daniel Douglas (3 months ago)
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!
Michael Clayton (3 months ago)
Very clear. Couldn't ask for more.
Abdul Rasheed (3 months ago)
Good one :)
Chakra Bracelet (3 months ago)
Now those diagrams finally make sense. What an excellent way to teach us joins!
Punkkikinkku (3 months ago)
Very well explained. Thank you
UB4000 (3 months ago)
Best explanation I came across
Gong Cheng (3 months ago)
best explanation on Join
osbone 007 (3 months ago)
i was pretty desparate then i watched your video now all is clear thank you from France
Mc Elep (3 months ago)
it is possible if I combined 3 classes?????
Taddele Petros (3 months ago)
wow it is great
Benjamin Swindle (3 months ago)
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!
poorna chander (3 months ago)
Thank you Joey blue for making this video..
xzc (4 months ago)
Great explanation, thank you
ask4apple (4 months ago)
thank you so much that was pretty easy but I wouldn't understand it without your video
V su (4 months ago)
Thanks Mr Chief Very nice explanation
Ba Ba (4 months ago)
It was awesome, thanks
Maciej K (4 months ago)
You're good at explaining.
Chris Vaccaro (4 months ago)
great explanation.. i made a spreadsheet that elaborates even more https://imgur.com/a/aGe67lB
DV (4 months ago)
Amazing Explanation!!!
Mr. McMurray (4 months ago)
Hello Joey, Awesome video. Question. I will be having an interview with a company in the next few day and SQL is major part of the interview. However, I will have to do the work on the board any suggestion and what I should be looking for in the interview
Alvan Rahimli (4 months ago)
Thank you, Man! The best join explanation! <3 love u!
Gavin Garcia-Brock (4 months ago)
Super helpful
Jerod Mclean (4 months ago)
Woohoo, English! :D
pasindu rangana (4 months ago)
thank you very much, it's very help Full
Rupak Kumar (4 months ago)
Great work, sir. Please, keep it up.
SinkOrSwim (4 months ago)
Joey, this tutorial help me understand what JOINS are finally! You know why? Because you’re actually teaching, and didn’t sound like in a hurry. Keep up the good work man! 🤙🏽
Monotoss (4 months ago)
I can't agree more with a comment, "Your is the only one that I understood". Same here. Absolutely brilliant explanation. Thanks so much Joey for making this awesome vids. You are the hero in SQL.
Amogha R (4 months ago)
Great work! Thanks a lot!
lukslda1 (5 months ago)
thank you! greetings from Argentina.
Symon (5 months ago)
great tutorial, understood like nothing!
Your Mother (5 months ago)
Dis is CityName taka orda prease.
Eli Makhoul (5 months ago)
thx man
RoXaS (5 months ago)
Thanks a lot! This short video summarised hours of my database classes. Totally recommendable! :)
Lyuben Zarev (5 months ago)
Finally, an English speaking SQL tutorial <3
David R (5 months ago)
really great, clear, and easy to understand explanation. The best I've seen. Thank you!
Rajesh Kalakoti (5 months ago)
What is GUI?
olabode oladipupo (5 months ago)
Thank you for this video. Now I understand well.
Ricardo Vaz (5 months ago)
Always great having classes from Trey Gowdy.
Comrade -Rashka (5 months ago)
Thanks you so much for this!
Murmad Man (5 months ago)
4:18 left (outer) join 9:40 MISC
Keshini Patel (5 months ago)
Simply BEST
neamenful (5 months ago)
rose blossoms (5 months ago)
wowwww…!! loved da way u explain..

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.