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
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.
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!!
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!
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.
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.
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
🙏!!! 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!
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.
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
They’re formally called left outer joins and right outer joins
“Outer joins” are called “full outer joins”
You made me understand this in 10 minutes, whereas I had no idea what was going on in my university lectures. Thanks lol
same!
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
same
Yes this one cleared the doubt in only 10 min
Same here
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.
This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it
The most simplified and relateable tutorial on Join
Thank you this is the best explanation I've found so far!
I agree, thank you :)
Totally agree 👍
Agreed!! Simple and easy to remember.
This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!
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!!
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!
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.
This is the most brilliantly laid out lesson I've watched on UA-cam
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.
OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man
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
That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.
Very well done, you covered in 10 minutes what I never grasped in years! Well Done!
🙏!!!
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!
Short, sweet and straight to the point... Great stuff!
Best join guide ive seen, and i feel like ive seen dozens of them. Thank you
Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha
Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!
This is one of the best explanation videos I've seen on youtube.
The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.
Best Video i have seen on joins, you did it better than any 1 hour video
simple and understood way to explain things that I have make me hate SQL one time but now anything is easy.
Thank you !
This video is so helpful that I've come back to watch it 4 separate times.
I really love the way you teach, its just amazing.
The visuals are so helpful!
The best and simplest explanation about table joins in sql so far
This is really great content! Your visual break down solved about a week of my frustration!!
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.
THANK YOU
Sincerely,
All visual learners everywhere
Hey Joma, this is the best explanation I found about Join so far! Thank you!!
Hands down the best explanation of the history of the universe
That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).
I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲
It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro
Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation
This is the best explanation and visualization of how joins work on youtube - thank you!
You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.
I honestly couldn't visual understand this concept until your explanation 🙏🤗👍best ever explanation thank you
Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins
Perfect explanation!! Simple and easy to understand!!
I can't thank you enough... hands down the best video for beginnners
I love how you explain!! Wish my professors were like u
You have explained these complex topics so nicely Cheers mate
Best video about joins so far
The best intuitive explanation of joins! Thanks a lot..
finally someone who knows how to teach!
Hey man,
This was the best explanation after so many videos. 💯
THANK YOU!
also tell good website for triggers ans stored procedures for visualization
Best explanation ever? Best explanation ever!
Thanks a lot!
I didn't know you know actually anything about coding! Good job!
Thank you for making this! Your explanation was clutch for my SQL exam tomorrow
Thank you so much. It was so easier to understand with the venn diagrams.
Thank you! This was 10 times easier than trying to read about it.
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.
YOYOYO these be very educational, keep it up Joma!~!~
This was the best explanation I've heard! Thank you
Thank you, it was very useful, cheers from Mexico!
WOW! thanks reading the same thing confused me a lot, just so easy this way!
bro made this shit look so easy. i even didnt get the content alone at that website. bruh
Best explanation of joins that I've seen, finally understood it now :)
You explained it in the best way possible. I hope we could see more of this (SQL) from you!
Tremendous explanation
Joma, you are the best!
Great explanation Joma ! , You should consider doing the entire SQL
i had no idea that there were different types of joins, thanks
Best explanation i've ever seen by far thank you!
best video with great explanation
salute to you man
Best JOINs video ever!!!
Interactive content and you made it so easy to learn! Thanks
Thanks for your simple explanation I finally understood the concept of each joins since I was being confused with them yesterday hehe
U explained Simple way and excellent👍
very nicely explained . Thanks for the video !
this website you mentioned is perfect. Thanks
THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!
Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.
''kind of like society... and dating'' my bro this take went so hard
Best demonstration ever
thank you Joma , this is extremely helpful
Awesome Joma, very clearly explained, keep the good SQL stuff content!!!
You are a good Teacher sir😍😍😍😍😍😍😍😍 Thank you from Bangladesh.
The best video ever for joins ❤️
Awesome Brother! Please upload more from DBMS
8:14 let go back,, truu Sounds great
Thank you ! my goodness. all the other examples were so complicated
You are a great teacher.
This is such an amazing explanation, so simple and clear! Thankyou
Fantastic job breaking this down 👍
Thanks Bro, I feel Like Snoop Dogg now, with this Joins.
Vzryy bery usefal video thnks joma. We want more video about sql and BI
It was very clear. Good job keeping it simple !
simple and straight forward. Thanks
THANK YOU SENPAI, this is awesome!!!!!!
Congrats for this very good video!!
clutching me up in my databases class actual plug
Vry nice explaination
Good Expiation easy to follow btw I'm a Collage Student And this is the most understandable expiation
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.
truly awesome! you made it look way easier than i thought, thank you
excellent explanation