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.
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.
🙏!!! 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!
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!!
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
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.
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!
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.
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 is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it
This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!
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.
That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.
This is the most brilliantly laid out lesson I've watched on RUclips
Very well done, you covered in 10 minutes what I never grasped in years! Well Done!
Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!
🙏!!!
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!
Best join guide ive seen, and i feel like ive seen dozens of them. Thank you
Short, sweet and straight to the point... Great stuff!
Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha
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!!
OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man
The visuals are so helpful!
I really love the way you teach, its just amazing.
simple and understood way to explain things that I have make me hate SQL one time but now anything is easy.
Thank you !
This is really great content! Your visual break down solved about a week of my frustration!!
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
Best Video i have seen on joins, you did it better than any 1 hour video
This video is so helpful that I've come back to watch it 4 separate times.
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.
The best and simplest explanation about table joins in sql so far
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.
Perfect explanation!! Simple and easy to understand!!
Hey Joma, this is the best explanation I found about Join so far! Thank you!!
This is the best explanation and visualization of how joins work on youtube - thank you!
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 so much. It was so easier to understand with the venn diagrams.
That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).
Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation
I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲
You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.
Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins
I love how you explain!! Wish my professors were like u
Best video about joins so far
finally someone who knows how to teach!
Hands down the best explanation of the history of the universe
This was the best explanation I've heard! Thank you
I can't thank you enough... hands down the best video for beginnners
Thank you! This was 10 times easier than trying to read about it.
I honestly couldn't visual understand this concept until your explanation 🙏🤗👍best ever explanation thank you
Best explanation ever? Best explanation ever!
Thanks a lot!
It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro
The best intuitive explanation of joins! Thanks a lot..
YOYOYO these be very educational, keep it up Joma!~!~
You have explained these complex topics so nicely Cheers mate
THANK YOU
Sincerely,
All visual learners everywhere
Thank you, it was very useful, cheers from Mexico!
Hey man,
This was the best explanation after so many videos. 💯
THANK YOU!
also tell good website for triggers ans stored procedures for visualization
Thank you for making this! Your explanation was clutch for my SQL exam tomorrow
this website you mentioned is perfect. Thanks
very nicely explained . Thanks for the video !
Interactive content and you made it so easy to learn! Thanks
Best JOINs video ever!!!
You explained it in the best way possible. I hope we could see more of this (SQL) from you!
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.
Best explanation of joins that I've seen, finally understood it now :)
I didn't know you know actually anything about coding! Good job!
Awesome Joma, very clearly explained, keep the good SQL stuff content!!!
Best demonstration ever
WOW! thanks reading the same thing confused me a lot, just so easy this way!
Joma, you are the best!
Best explanation i've ever seen by far thank you!
You are a great teacher.
thank you Joma , this is extremely helpful
best video with great explanation
salute to you man
This is such an amazing explanation, so simple and clear! Thankyou
Thanks for your simple explanation I finally understood the concept of each joins since I was being confused with them yesterday hehe
Thank you ! my goodness. all the other examples were so complicated
Thank you for your clear explanation! It helped a lot!❤
It was very clear. Good job keeping it simple !
This is the video that um looking for...Thanks for this video
Fantastic explanation! Thank you so much for making it so simple and clear.
simple and straight forward. Thanks
U explained Simple way and excellent👍
i had no idea that there were different types of joins, thanks
The best video ever for joins ❤️
Thanks for the video, very easy to understand and helpful
Super informative and easy to watch. Thanks!
Tremendous explanation
Great explanation Joma ! , You should consider doing the entire SQL
Best video !
Thank you
I understand all about joins!
truly awesome! you made it look way easier than i thought, thank you
thank you for this, very helpful
I refer back to the website from time to time
Vzryy bery usefal video thnks joma. We want more video about sql and BI
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!
Gold. Pure gold. lol Thanks for the summary. Great job!
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.
This is really good explanation of joins. Thank you! 👏🏼
Fantastic job breaking this down 👍
clutching me up in my databases class actual plug
Thank you for this quick refresher!!
Congrats for this very good video!!