MySQL: JOINS are easy (INNER, LEFT, RIGHT)

[@BroCodez]

-- INNER JOIN selects records that have a matching key in both tables. SELECT * FROM transactions INNER JOIN customers ON transactions.customer_id = customers.customer_id; -- LEFT JOIN returns all records from the left table -- and the matching records from the right table SELECT * FROM transactions LEFT JOIN customers ON transactions.customer_id = customers.customer_id; -- RIGHT JOIN returns all records from the right table -- and the matching records from the left table SELECT * FROM transactions RIGHT JOIN customers ON transactions.customer_id = customers.customer_id;

[@__VishnuPrakashB]

can you explain Full join?

[@Propain4eva]

🐐

[@rah.248]

I was fighting for my life trying to comprehend joins before I watched this video, KZbin really is a life saver. Thank you!

[@siyabongagift4168]

Bro you just made it look easy, you the best

[@TheL0rdOfTheStrings]

Man crazy how simple but effective your explanation is. I was scouring blogs for hours in order to understand this. Thanks a ton

[@AMPAROLawrenz]

that was it? I was crying for four hours because I couldn't understand anything in class and that was it? it was that freaking simple?

[@essentiallifter7103]

Lmao same

[@techtwithme6727]

Maybe you're stupidd enough

[@silviauzie4958]

Same 😭😂but didn’t cry

[@LaughingMan44]

Damn, you have a useless lecturer too?

[@mawesome4ever]

@@silviauzie4958I only cried after watching this video

[@Vishwas696]

INNER JOIN = Show what is common in both table LEFT JOIN = Shows the full left table but the only the common items from the right table RIGHT JOIN = Shows the full right table but the only the common items from the left table Thank you bro for such a simple explanation 🙏🙏🙏🙏

[@jayeshrahulkovi9738]

But why we need different types , what is the purpose of each ?

[@christophergruendell8089]

I'm taking a class for SQL programming and the professor has 3 powerpoints, each about 20 slides long, for joins. Even with all of that, I couldn't figure it out. Your video had me understanding this by the 3 minute point though. Thank you! Whatever you're doing keep it up!

[@edb484]

hell yea lol it kills how schools make things longer than they should. I remember taking a Calculus class and a 45 mins video taught you everything in a whole semester better than the Professor. everyone skipped the class unless it was test day

[@exile8110]

@@edb484 This reminds me of my database managment teacher who made me have a mental break down, I have therapay session to this day because this man. he couldnt teach what bro code could teach me in five minutes.

[@shadowrealm8937]

@@edb484 what video was that?

[@Deven210]

@@shadowrealm8937 More than likely a Kaan Academy Video. Absolutely great content. He will help you understand math you never thought you could before.

[@MohitYadav-be1ju]

My teacher was explaining us about joins today and I was like why is this so tough to understand, questioning my cognitive abilities. Turns out it's not me it's my lovely teacher, sometimes its not about the knowledge I guess its about the delivery. Still huge respect for my teacher shes a complete monster in SQL . Thanks bro you made my life easier

[@AymanAli51]

4:57 `and that is a quick introduction` bro you explained it all, thanks.

[@BloxxingDinosaurus]

Really amazing informative video, mentioning stuff one barely ever thinks about, let alone finds a solution to when one does think about it. This is the first time I heard of Mrs. Puff's first name being Poppy, thank you for mentioning it in this video, I wish I had seen this many years earlier.

[@markbarton6845]

That probably the best and simplest explanation I ever seen in a MySQL tutorial . Great video, thanks so much for taking the time to make it.

[@explore-learn-share6937]

I have seen many videos but i could only understand concept of JOINS from your simple video. Very beautifully explained here

[@nthextellar2239]

My teachers unironically had to spend 3-4 hours explaining this, and I didn't understand anything of what they said. I then come to this video, only to understand it in 3 mins, damn, you're the best, thank you

[@aikasal5214]

BRUH, YOU MADE IT MUCH MORE EASIER FOR ME!!!!!!!!!!! However I'm learning SQL and I'm so much of a newbie that I don't know if the syntaxes are about to be different or not, but you broke it down me and clear for me. Salute to you bro. I really appreciate the clarity you brought to us.

[@PedroHoffmann]

English is not even my native language and I still learned more in 5 minutes with you than in 15 KZbin videos.

[@celestes8072]

Thank you so much for this. I have a midterm today on SQL and I was having the HARDEST time understanding left and right join. This is the best video I have seen explaining it!

[@ReneAshu-fb5fd]

This is a masterful explanation that is very easy to expand on. Even though he used particular examples, he made it so easy to see a pattern. Thank you for such these 5 minutes of elegance.

[@kunalprasad4215]

Wasted 2 hours on this concept and finally got it from this video in less than 20 minutes. Nice work dude keep it up.

[@thomasbrablec1149]

I just got to the JOIN section in the Google Data Analytics certification and couldn't figure this out. Their example ended up being an exception where they stated that JOIN would work, and then reiterated how important it is to use the right JOIN. This video explained the concept much more clearly and I finally feel like I have a good grasp of what I'm looking at. Thank you!

[@RayAndrewsDev]

If somebody would have explained it to me like this years ago it would have saved young me so much frustration. Building up a list of people I need to send this to :) Great tutorial

[@M.A.PROHOR]

It's been three day's i have been trying to understand wtf is join . and now it took only 5 minutes bro never disappoints

[@oussKhayi]

You made it soooo easy ❤ I always avoided understanding it, thinking it was too difficult 😫

[@gabrielreyes8324]

This comment could be me too, thank you!

[@WilliamGabriel-fp5dj]

Hi from brazil! I TOTALLY agree with u

[@faithff4948]

Han serbha

[@Nicholasiz]

by far the best description been studying this for hours but u explained it clearly

[@AdrianTregoning]

I watched all your Java videos (and did the exercises myself). Now I find myself back on your channel and as always: crystal clear and understandable! Thanks Bro!

[@kamrulislam3841]

That was so simply powerful video on JOINS. You are great man!

[@stevenvillarreal8970]

Great video! You made it 100% easier to understand than my professor back in college! Simple and to the point, love it!

[@josephwinstead3525]

I take the ISC section of the CPA exam Monday - this is such a huge help. Thanks for making this

[@raevenconsolacion2449]

I had watched a lot of videos of this Yet i still couldnt get it But you explained it very simple and the best Like youre really talking to a beginner Even a person with no experience in programming languages could understand thix Thank you

[@noliiiivaldez7861]

did this years ago in college, did not learn by heart. need to use now in work, found a semester worth of knowledge

[@thecatman9o9]

This is quicker than the quickest quickie I ever had. thank you

[@Crowmeir]

Thank you so much bro! This man is single handedly saving me from understanding coding concepts that i find hard to understand. Every single time I struggle with a topic bro has a vid on it 😂 (especially on data structures lol)

[@danitaupe1230]

Lovin' the fact that you were very specific with the topic. Nice video!

[@Old3nough]

Ok thank you for this because I was having the hardest time understanding JOINS!! Great and well explained video !!

[@nafissadik]

Simple, precise, to the point! Really loved it! Absolutely awesome and very helpful!

[@ShreshthaGusain]

you are a hero. you are a savior. youre the messiah

[@komalthecoolk]

SIR, I mean BRO, you have done it. The most beautiful explanation of this concept on the internet. Subscribed.

[@kristopherthompson1342]

You're my hero. I'm taking the SQL course from UC Davis on Coursera, and the instructor did a terrible job at explaining joins. This made it so much easier.

[@sahilrawat7966]

bruh 1 was abt to watch 3 videos of half an hour each for them tysm

[@kodiq3429]

Why my profesor couldnt have said it in 1,5h lecture … You are amazing

[@manasranjanbera25]

You're the real saviour. Really very good explanation

[@barsha9262]

Your video was a fantastic explanation. It is the easiest to grasp these topics by exercise and hands-on project like i've done today. Perfect complement for experience!

[@muktarsayeed9198]

Very nice example, best one I've looked at on youtube 🙏🙏🙏🙏 i particularly like the venn diagram approach - "a picture is worth a thousand words"

[@contactdi8426]

OMG!! Bro code you are really a true bro! You made it super easy to understand. I always avoided it assuming it'll be very difficult concept to understand. Thanks a lot bro

[@Mikaas111]

Thank you so much for this video. I understand it now. I had an sql class about this subject that was *really* long and to be honest I forgot everything I didn't write down. This helped a lot!

[@gandamraviteja7019]

Thank you so much for your you just made everything so clear where lot of tutorials takes hours but still end up failing clearing or delivering the concept even thanks feels tiny for your work

[@passportbro904]

oops, or as my bro use to say (poop) lol, if u know u know, he did it again, smh, this guy is something else, really a blessing. God bless you bro

[@Prakeet1995]

That's a really good explanation. Thanks.

[@juliep.6824]

Thanks for this. Man I trying to understand joins for the longest and your video was to the point and my light bulb just went off 😂

[@ethanshutika8621]

This explained it so much easier and made sense versus my course textbook and labs.

[@cypher4528]

Thanks bro! I understood everything from this 5min video than I did in the last 30mins from the W3School page.

[@TJKlimoski]

One of the best explanations I've seen on this topic. thank you so much!

[@xChikyx]

ok, best explanation about joins i've seen

[@darkseid94]

This is the best and easiest explanation for joins on the Internet-better than that UDEMY course from Jose Portilla.

[@CSSANJAYR]

while watching this vid ,I was a bit confused abt the joins.But later peeking the first comment it got cleared! ++

[@amonraii7273]

You really are a bro man, no kidding.

[@sampathchary9155]

That venn diagram alone explained most of the part.You really made it easy Bro!!

[@andrewcenteno3462]

That was the best explanation i've ever heard for this

[@shadowplayer11.86]

sheesh. I used to think this was hard when my professor first taught it 2 years ago, but now it looks so basic. Thanks Bro Code

[@shawnchristophermalig4339]

Bruh... You made it easy. Truly, bro code!!!

[@RG-500]

Thank you so much for posting this video. You did an excellent job explaining it in easy to understand terms. Very helpful! Cheers!

[@serifaygun9381]

can not be explained easier than this way, great work

[@anikakoob2633]

You make this so easy to understand. Thank you!

[@ТарасСінчук]

Thank you! It was really much more helpful than understanding that on my own) simple and clean

[@NutchanonC]

I finally understood joins. Never really understood them while I was in college lol. Thank you.

[@oyakalesola7458]

Thank you for making this video, straight simple and giving a superb explanation.

[@vinalpawar7488]

Wow, how does he make it look so simple? Amazing work!

[@tung-hsinliu861]

This explains so clearly with examples provided! Thankyou!

[@FlameEnzo]

And this is how I learned Mrs. Puff's first name lol. Nice video, very helpful!

[@arnoldbhebhe]

love the use venn diagram to visualize the joins - thanks!

[@0Nardock0]

The best explanation I ever found on yt, thank you bro.

[@Warden_Here]

this is the best explain I've ever seen!

[@TheShawn_v]

easest way someone can explain joins

[@tharaks552]

love from india , you made it very easy peasy ❤‍🔥

[@coleford6197]

I think I speak for everyone in the comment section when I say thank you, Bro Code.

[@skrullmania4808]

you are so good at these explanations, thank you so much

[@ИльясНуруясов-в2э]

Good video, thank you

[@brahimlagueb5909]

Thanks for clarify the inner join option ! you made it easy to understand

[@methanesulfonic]

Than Venn diagram alone single handedly make this topic way easier than it should be. As always, Thank you!!

[@AmandeepSinghP1]

thanks brother for very easy understanding of sql joins,it realy helps me to understand joins in sql. 😄

[@umangupreti9107]

Thank you boss. Plain & Simple explanation 👏

[@outoftime687]

you made it so easy to comprehend thanks v much. 🙏🏼

[@TutorialStation]

Thanks. Clear video and loced your Sponge Bob naming as the cusomers 😂

[@TheTrippyTerminal]

Amazing explanation man, you should be my teacher.

[@sakshamchhatkuli271]

Thank you so much!

[@christiangeorge5313]

You are just too good. Thanks for the Explanation

[@muzika5001]

Needed fast reminder on joins. And this video made things very easy. Thank you! 👍

[@UshaRani-mj3hg]

Thankyou sir for giving a clear explanation 🙏

[@Andrey7923]

Thanks for your work, this video-lesson is easy for me as a newbie

[@phiwokuhlenkosi1419]

Watching this an hour before my semester exam.

[@crispydosa_]

its- ITS THAT SIMPLE???? I DIDN'T UNDERSTAND SHIT IN CLASS THANKYOU SM

[@kostasoriginal181]

Thanks a lot I really thought joins were confusing as hell but they seem simple

[@ab_obada5012]

As always, the best of the best ❤

[@Honcho35]

You are an amazing teacher brother

[@GoViral-fi8dh]

Clean and eloquently explained!

[@kuhome-lw9to]

The best video in joins 🍯

[@marcusvinicius7510]

Thank you so much! Very didactic and so much easier to understand.

[@yker8913]

Thanks! You made it so easy.

[@di-egohumilde4515]

Thank you so much, now I understand wayyy better

[@itsnevertoolatetolearn4875]

wow , very articulate explanation

[@aadhiyanth5969]

Learnt Python with you, now begins SQL too