SQL Joins: Difference Between Inner/Left/Right/Outer Joins

Join Jomaclass for full-length videos like this: joma.tech/dsa

[@LaughinLoneStar]

Join/Inner Join = Keep only that which matches Left join = Keep every thing from left table, only matches from right table Right join = Keep everything from right table, only matches from left table Outer join = Keep everything

[@j.deluca8824]

You made me understand this in 10 minutes, whereas I had no idea what was going on in my university lectures. Thanks lol

[@sebastianvalenzuela3762]

same!

[@sagardubey3800]

same this side even........Universities have pro max teachers and he is just a teacher that's the reason we are not understanding anything from there

[@Stavros33GR1]

same

[@azimrahman3584]

Yes this one cleared the doubt in only 10 min

[@naimaaqeel8092]

Same here

[@Hoppensagen]

Seriously, why do teachers not explain it simply like this, I was so confused, they just like explained in words what join is, and then write sql and show it and then I just have no idea what happened. Great visual.

[@LoXena]

Thank you this is the best explanation I've found so far!

[@michellekelly1220]

I agree, thank you :)

[@Chandni_geet]

Totally agree 👍

[@BronProject]

Agreed!! Simple and easy to remember.

[@blindhydra]

This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it

[@programmingwww]

This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!

[@thanhsangto8603]

That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.

[@fndfgbberb]

Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha

[@melissaduran6319]

I know people say this in nearly all programming/comp sci videos but yours was hands down the best explanation for this concept! I was only finding videos explaining the SQL but I am not learning that yet in my class so I didn't find it useful watching tutorials on it. Thank you so much for this detailed and thorough explanation!

[@luisgaxiola-baqueiro6105]

Exactly, I have seen these boring theoretical explanations which make me be more confused at the end than I was at the beginning, but this explanation is just easy and so well explained.

[@michaelkalu918]

The most simplified and relateable tutorial on Join

[@markovujanic]

Thanks for all animations and grate narration, I think we can improve on the mental model of your presentation, especially for outer joins. Inner Join 1. Cartesian product created 2. Keep rows matching condition (USING/ON) Left Join 1. Cartesian product created 2. Keep rows matching condition (USING/ON) 3. Left join (add back left table unmatched rows, assign them to null) Most important part is that every JOIN starts with Cartesian product, then some filtering + variation

[@stol3nsoul504]

my teacher spend literally 3 full hours trying to explain this as complicated as he could, I didnt understand a single word. 10 minute video from you and boom i got it. Thanks so much buddy!!

[@rubenkanya7342]

Very well done, you covered in 10 minutes what I never grasped in years! Well Done!

[@krissstories5586]

OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man

[@billnye7252]

Thank you so much for the easy to understand video. My a whole lecture of class understandable in 10 minutes. The visuals helped a LOT.

[@shigriasif1316]

You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.

[@jaymanzoom]

Didn't matter how I asked my teacher I couldn't understand what the hell the differences between the joins were. Thank you for making it so easy and showing visual examples.

[@dalitsobotha7932]

Short, sweet and straight to the point... Great stuff!

[@gssj-o8p]

Hands down the best explanation of the history of the universe

[@namphantech]

It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro

[@Ray-xl9iz]

Best join guide ive seen, and i feel like ive seen dozens of them. Thank you

[@mohamedsuhailirfankhazi6628]

Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!

[@sparrowXXIII]

🙏!!! I desperately needed a visual explanation like this. Going to dive in your other videos and see what other magic visualizations you have up your sleeve!

[@pauloxavier3033]

Perfect explanation!! Simple and easy to understand!!

[@alpha-mf9rh]

The visuals are so helpful!

[@proCode10]

This is one of the best explanation videos I've seen on youtube.

[@shubhampendbhaje9976]

I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲

[@keylanshannon9492]

This is really great content! Your visual break down solved about a week of my frustration!!

[@FleeurFleeur]

This was the best explanation I've heard! Thank you

[@Gn0ume]

I didn't know you know actually anything about coding! Good job!

[@t.l.e.e.]

finally someone who knows how to teach!

[@tabithae3679]

This video is so helpful that I've come back to watch it 4 separate times.

[@martinamilitello3893]

Best explanation ever? Best explanation ever! Thanks a lot!

[@송예은-h7b]

Hey Joma, this is the best explanation I found about Join so far! Thank you!!

[@milindsagar3630]

I really love the way you teach, its just amazing.

[@missstella1584]

Best video about joins so far

[@rahulmahbubani1392]

Best Video i have seen on joins, you did it better than any 1 hour video

[@omyni]

THANK YOU Sincerely, All visual learners everywhere

[@VeronicaAngryPolak]

THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!

[@Rextirant]

YOYOYO these be very educational, keep it up Joma!~!~

[@ayoubbellaoui5833]

simple and understood way to explain things that I have make me hate SQL one time but now anything is easy. Thank you !

[@shadynit]

this website you mentioned is perfect. Thanks

[@lppap9774]

Hey man, This was the best explanation after so many videos. 💯 THANK YOU!

[@gentleechoes6]

also tell good website for triggers ans stored procedures for visualization

[@mzamomahaeng268]

I honestly couldn't visual understand this concept until your explanation 🙏🤗👍best ever explanation thank you

[@001tolky]

That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).

[@meme1033]

This is the best explanation and visualization of how joins work on youtube - thank you!

[@fg0611]

The best and simplest explanation about table joins in sql so far

[@codealong2456]

WOW! thanks reading the same thing confused me a lot, just so easy this way!

[@hibamariam4405]

damn never thought i could learn joins in 10mins...thanks much!

[@backendadmin1217]

The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.

[@hobbyboy218155]

Thank you for making this! Your explanation was clutch for my SQL exam tomorrow

[@danielcortes4057]

Thank you, it was very useful, cheers from Mexico!

[@Exceltech810]

Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins

[@siamimam2109]

I love how you explain!! Wish my professors were like u

[@manavdubey7670]

very nicely explained . Thanks for the video !

[@Morexod999]

Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation

[@adamdudkiewicz6444]

i had no idea that there were different types of joins, thanks

[@eliasalvarez6881]

Best JOINs video ever!!!

Awesome Joma, very clearly explained, keep the good SQL stuff content!!!

[@akindelelekan614]

Tremendous explanation

[@SamBaltimore]

Thanks Bro, I feel Like Snoop Dogg now, with this Joins.

[@Roodementary]

Thank you! This was 10 times easier than trying to read about it.

[@katerynariaboshapko4037]

Joma, you are the best!

[@KhianVictoryDCalderon]

Thank you, i've understand it very well, even chatgpt can't explain to me clearly, it still complicated but this video is very clear.

[@Julie-lb6pw]

Thank you ! my goodness. all the other examples were so complicated

[@nosebleed4304]

Good Expiation easy to follow btw I'm a Collage Student And this is the most understandable expiation

[@Sebochan]

You explained it in the best way possible. I hope we could see more of this (SQL) from you!

[@caesarcastro9583]

simple and straight forward. Thanks

[@fahadjavaid7126]

You have explained these complex topics so nicely Cheers mate

[@mariaelisha]

best video with great explanation salute to you man

[@melvinwookiee2696]

I can't thank you enough... hands down the best video for beginnners

[@DanielLopez-gi8oy]

omg this video made me understand thissss. Finally, I love u man

[@twoadventureus]

Gold. Pure gold. lol Thanks for the summary. Great job!

[@user-cx5wq9rn6e]

bro made this shit look so easy. i even didnt get the content alone at that website. bruh

[@bhushanssable9641]

The best video ever for joins ❤️

[@MdForhad-fy7vx]

This is the video that um looking for...Thanks for this video

[@Bdlover-24]

You are a good Teacher sir😍😍😍😍😍😍😍😍 Thank you from Bangladesh.

[@subhamchakraborty6822]

Awesome Brother! Please upload more from DBMS

[@solojohno1]

Outstanding video. Sub'd. This was explained so well that, by about 3 or 4 minutes into the video, I could anticipate the explanation of everything coming. And that's on a topic that I had previously found confusing. Nice work. I really appreciate it!

[@davidemmanuel3001]

Best demonstration ever

[@iuliannegoescu9887]

Best video ! Thank you I understand all about joins!

[@SzrIsTaken786]

clutching me up in my databases class actual plug

[@gloriyathomas]

The best intuitive explanation of joins! Thanks a lot..

[@kukkakaali1751]

Best explanation of joins that I've seen, finally understood it now :)

[@jazzryjamz]

I spent so long looking at docs and even pictures didn't make sense to me. I feel hella dumb after understanding joins within the first 4mins of listening to you, thank you.

[@michealbailey6372]

Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.

[@zulzarifzahir2004]

You are a great teacher.

[@harinderjeetrandhawa5998]

Thanks for making me understand this concept; I am writing this comment just one and a half hours before my exam. I hope I do well

[@rajireddymutyala4217]

U explained Simple way and excellent👍

[@TheAjayTyler]

Fantastic job breaking this down 👍

[@matheus4lvesfcc]

Thanks for this video and for the website recommendation.

[@theinthanhlan3582]

He explained with in 11 minutes!!!!!!!!cool!!

[@azhar6055]

thank you Joma , this is extremely helpful

[@amalkrishnas1696]

Thanks for the video, very easy to understand and helpful

[@ugonmaajie2240]

You're the best. Wow!!! I got it and well understood. ❤

[@ghaziali3504]

Interactive content and you made it so easy to learn! Thanks

[@senseiimoh]

Vzryy bery usefal video thnks joma. We want more video about sql and BI

[@TheBirdChannelOriginal]

thanks for very simple and clear describing

[@daryllculas6894]

Thanks for your simple explanation I finally understood the concept of each joins since I was being confused with them yesterday hehe

[@nymrod6620]

Great explanation Joma ! , You should consider doing the entire SQL