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

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

[@SumpNuther]

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

[@dalitsobotha7932]

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

[@carsonXXIII]

🙏!!! 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!

[@Ray-xl9iz]

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

[@meme1033]

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

[@keylanshannon9492]

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

[@Sebochan]

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

[@fndfgbberb]

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

[@thanhsangto8603]

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

[@user-dc7oj3el7o]

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.

[@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!

[@mohamedsuhailirfankhazi6628]

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

[@rahulmahbubani1392]

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

[@krissstories5586]

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

[@ayoubbellaoui5833]

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

[@Rextirant]

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

[@programmingwww]

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

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

[@001tolky]

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

[@chrisnandasaputra2708]

THANK YOU SENPAI, this is awesome!!!!!!

[@michaelkalu918]

The most simplified and relateable tutorial on Join

[@Morexod999]

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

[@backendadmin1217]

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

[@ghaziali3504]

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

[@hanmuhammetbahtiyarov1644]

truly awesome! you made it look way easier than i thought, thank you

[@VeronicaAngryPolak]

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

[@melvinwookiee2696]

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

[@danielcortes4057]

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

[@proCode10]

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

[@Exceltech810]

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

[@rubenkanya7342]

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

[@azhar6055]

thank you Joma , this is extremely helpful

[@DanielLopez-gi8oy]

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

[@yanivshabi288]

It was very clear. Good job keeping it simple !

[@siamimam2109]

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

[@fg0611]

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

[@iuliannegoescu9887]

Best video ! Thank you I understand all about joins!

[@michealbailey6372]

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

[@FleeurFleeur]

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

[@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!!

[@zayonnieves7035]

Fantastic explanation! Thank you so much for making it so simple and clear.

[@gloriyathomas]

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

[@bhushanssable9641]

The best video ever for joins ❤️

[@shigriasif1316]

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

[@basavarajpatil9821]

Great joma loved it

[@mraprilonempeno]

This is really good explanation of joins. Thank you! 👏🏼

[@missstella1584]

Best video about joins so far

[@TheAjayTyler]

Fantastic job breaking this down 👍

[@pauloxavier3033]

Perfect explanation!! Simple and easy to understand!!

[@hipman21]

This is such an amazing explanation, so simple and clear! Thankyou

[@MdForhad-fy7vx]

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

[@fahadjavaid7126]

You have explained these complex topics so nicely Cheers mate

[@itgetsdajobdone]

Thank you for this quick refresher!!

[@djung8667]

Congrats for this very good video!!

[@Roodementary]

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

[@eliasalvarez6881]

Best JOINs video ever!!!

[@kukkakaali1751]

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

[@roman_mf]

Great visualization, thank you so much :)

[@rahulvaish3034]

Thanks for posting this video !!

[@syhbeats]

great video! helped me refresh my knowledge of joins!!

[@alpha-mf9rh]

The visuals are so helpful!

[@jafetcalderon9505]

Man, this was so dam good!

[@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.

[@codealong2456]

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

[@namphantech]

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

[@hasanozdemir1067]

Thank you so much for the video. It is super clear!

[@mzamomahaeng268]

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

[@hobbyboy218155]

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

[@Milen.Yodanov]

WOW that was amazing thanks brother!

[@thatomotaung6891]

Such a good teacher, thanks for this.

[@ugonmaajie2240]

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

[@Sean-uo9kw]

Super informative and easy to watch. Thanks!

[@lppap9774]

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

[@ahlamazam6211]

also tell good website for triggers ans stored procedures for visualization

[@melsmakeup9133]

Best video on youtube, thank you so much

[@gevon1520]

Thank you so much! I now understand it.

[@manavdubey7670]

very nicely explained . Thanks for the video !

[@nymrod6620]

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

[@shadynit]

this website you mentioned is perfect. Thanks

[@mariaelisha]

best video with great explanation salute to you man

[@pallavishah6665]

Amazing man, thank you!

[@mohamedlellah8318]

Thank you. This is a great video

[@martinamilitello3893]

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

[@pranavkrishna6835]

Amazing lessons brother 🔥🙏

[@natalevelardi1585]

Best explanation i've ever seen by far thank you!

[@_thattallguy__]

This is actually helping me thankx👍

[@zulzarifzahir2004]

You are a great teacher.

[@kalocsaymate8838]

Damn so clear video and so underreated. Thank you.

[@JSunmonu]

this was incredibly helpful thank you so much

[@daniellukyanchuk4642]

Maan, such a great explanation! Keep on the good work!

[@biggyk87]

Thanks dude, much appreciated.

[@tabithae3679]

This was SUPER helpful! Thank you! 🥺

[@omyni]

THANK YOU Sincerely, All visual learners everywhere

[@caesarcastro9583]

simple and straight forward. Thanks

[@abdurazzoqyoqubjonov1545]

Phenomenal, phenomenal phenomenal 👌👌👌👌.

[@tabithae3679]

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