-- 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;
@__VishnuPrakashB7 ай бұрын
can you explain Full join?
@Propain4eva22 күн бұрын
🐐
@user-we2oy6fn4g9 ай бұрын
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?
@essentiallifter71039 ай бұрын
Lmao same
@techtwithme67279 ай бұрын
Maybe you're stupidd enough
@silviauzie49589 ай бұрын
Same 😭😂but didn’t cry
@LaughingMan448 ай бұрын
Damn, you have a useless lecturer too?
@mawesome4ever8 ай бұрын
@@silviauzie4958I only cried after watching this video
@siyabongagift4168 Жыл бұрын
Bro you just made it look easy, you the best
@Vishwas6962 ай бұрын
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 🙏🙏🙏🙏
@Metro2484 ай бұрын
I was fighting for my life trying to comprehend joins before I watched this video, KZbin really is a life saver. Thank you!
@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!
@edb4847 ай бұрын
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
@exile81104 ай бұрын
@@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?
@TheL0rdOfTheStrings5 ай бұрын
Man crazy how simple but effective your explanation is. I was scouring blogs for hours in order to understand this. Thanks a ton
@markbarton68459 ай бұрын
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.
@oussKhayi Жыл бұрын
You made it soooo easy ❤ I always avoided understanding it, thinking it was too difficult 😫
@gabrielreyes832411 ай бұрын
This comment could be me too, thank you!
@WilliamGabriel-fp5dj7 ай бұрын
Hi from brazil! I TOTALLY agree with u
@faithff494814 күн бұрын
Han serbha
@AymanAli51Ай бұрын
4:57 `and that is a quick introduction` bro you explained it all, thanks.
@MohitYadav-be1ju7 ай бұрын
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
@thomasbrablec11493 ай бұрын
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!
@ReneAshu-fb5fd10 ай бұрын
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.
@aikasal52148 ай бұрын
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.
@kristopherthompson134210 ай бұрын
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.
@celestes80725 ай бұрын
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!
@kunalprasad42157 күн бұрын
Wasted 2 hours on this concept and finally got it from this video in less than 20 minutes. Nice work dude keep it up.
@thecatman9o9Күн бұрын
This is quicker than the quickest quickie I ever had. thank you
@RayAndrewsDev5 ай бұрын
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
@stevenvillarreal89708 ай бұрын
Great video! You made it 100% easier to understand than my professor back in college! Simple and to the point, love it!
@raevenconsolacion244911 ай бұрын
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
@nafissadik8 ай бұрын
Simple, precise, to the point! Really loved it! Absolutely awesome and very helpful!
@darkseid944 ай бұрын
This is the best and easiest explanation for joins on the Internet-better than that UDEMY course from Jose Portilla.
@gandamraviteja70197 күн бұрын
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
@noliiiivaldez78613 ай бұрын
did this years ago in college, did not learn by heart. need to use now in work, found a semester worth of knowledge
@arnoldbhebhe4 күн бұрын
love the use venn diagram to visualize the joins - thanks!
@RG-5007 күн бұрын
Thank you so much for posting this video. You did an excellent job explaining it in easy to understand terms. Very helpful! Cheers!
@nthextellar22396 ай бұрын
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
@andrewcenteno3462Ай бұрын
That was the best explanation i've ever heard for this
@AdrianTregoning4 ай бұрын
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!
@Nicholasiz2 ай бұрын
by far the best description been studying this for hours but u explained it clearly
@Prakeet19958 ай бұрын
That's a really good explanation. Thanks.
@Warden_Here2 күн бұрын
this is the best explain I've ever seen!
@sahilrawat7966 Жыл бұрын
bruh 1 was abt to watch 3 videos of half an hour each for them tysm
@kodiq342910 ай бұрын
Why my profesor couldnt have said it in 1,5h lecture … You are amazing
@Mikaas1119 ай бұрын
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!
@vinalpawar748820 күн бұрын
Wow, how does he make it look so simple? Amazing work!
@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
@ethanshutika862110 ай бұрын
This explained it so much easier and made sense versus my course textbook and labs.
@tung-hsinliu86111 ай бұрын
This explains so clearly with examples provided! Thankyou!
@TheShawn_v2 ай бұрын
easest way someone can explain joins
@passportbro9043 ай бұрын
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
@amonraii72737 ай бұрын
You really are a bro man, no kidding.
@oyakalesola7458Ай бұрын
Thank you for making this video, straight simple and giving a superb explanation.
@NutchanonC11 ай бұрын
I finally understood joins. Never really understood them while I was in college lol. Thank you.
@muktarsayeed91985 ай бұрын
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"
@TutorialStation4 ай бұрын
Thanks. Clear video and loced your Sponge Bob naming as the cusomers 😂
@TJKlimoski5 ай бұрын
One of the best explanations I've seen on this topic. thank you so much!
@juliep.68248 ай бұрын
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 😂
@sargata30548 күн бұрын
Thank you!! This is so easy to understand.
@serifaygun93815 ай бұрын
can not be explained easier than this way, great work
@marcusvinicius75102 ай бұрын
Thank you so much! Very didactic and so much easier to understand.
@heinzguderian301010 ай бұрын
I think this channel is an A.I. which is running by itself. The voice, the simplicity of the narration, the video explanation. Everything is precise.
@crispydosa_4 ай бұрын
its- ITS THAT SIMPLE???? I DIDN'T UNDERSTAND SHIT IN CLASS THANKYOU SM
@mussimbigrace34694 ай бұрын
you just earned yourself a new subscriber !! thank youuu!!!
@brahimlagueb590910 ай бұрын
Thanks for clarify the inner join option ! you made it easy to understand
@sampathchary9155 Жыл бұрын
That venn diagram alone explained most of the part.You really made it easy Bro!!
@FlameEnzo Жыл бұрын
And this is how I learned Mrs. Puff's first name lol. Nice video, very helpful!
@shadowplayer11.869 ай бұрын
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
@shawnchristophermalig43399 ай бұрын
Bruh... You made it easy. Truly, bro code!!!
@gpabokan9 ай бұрын
Clear and concise, no more needed. Thanks!
@tharaks552Күн бұрын
love from india , you made it very easy peasy ❤🔥
@GoViral-fi8dh3 ай бұрын
Clean and eloquently explained!
@cypher45289 ай бұрын
Thanks bro! I understood everything from this 5min video than I did in the last 30mins from the W3School page.
@tarunthomas81233 ай бұрын
short yet super informative .
@Honcho35Күн бұрын
You are an amazing teacher brother
@isar.h82582 ай бұрын
I thought it was more complicated! Thanks
@MsScarymoe6 ай бұрын
So well explained, my instructor made this so needlessly confusing.
@CSSANJAYR Жыл бұрын
while watching this vid ,I was a bit confused abt the joins.But later peeking the first comment it got cleared! ++
@xanhxanh50978 ай бұрын
every developer should watch this video :)
@yker891310 ай бұрын
Thanks! You made it so easy.
@catcatcat28993 ай бұрын
that was so straightforward and quick, ty!
@mrcaljoe1 Жыл бұрын
brilliant and concise!
@Andrey79236 ай бұрын
Thanks for your work, this video-lesson is easy for me as a newbie
@CP-xu2pj10 ай бұрын
The best video so far
@phiwokuhlenkosi14192 ай бұрын
Watching this an hour before my semester exam.
@tinanguyen10728 күн бұрын
Best explanation hands down
@muzika5001 Жыл бұрын
Needed fast reminder on joins. And this video made things very easy. Thank you! 👍
@kostasoriginal1819 ай бұрын
Thanks a lot I really thought joins were confusing as hell but they seem simple
@0Nardock011 ай бұрын
The best explanation I ever found on yt, thank you bro.
@sakshamchhatkuli2715 ай бұрын
Thank you so much!
@lokesh33658 ай бұрын
neat and clean and simple way
@ab_obada50123 ай бұрын
As always, the best of the best ❤
@liorschifrin9 ай бұрын
Wow. You made that so easy. Thank you
@TheTrippyTerminal5 ай бұрын
Amazing explanation man, you should be my teacher.
@ryanmelecio60028 ай бұрын
Bro did it better than our teacher
@kuhome-lw9to3 ай бұрын
The best video in joins 🍯
@calvinchao057 ай бұрын
Omg this video made everything make so much sense
@BB-fs4qi3 ай бұрын
Maaan you are GOD! Pretty simple explanation! AWSAME!
@Felipe1591 Жыл бұрын
Thanks for that man! I finally understood it!
@UshaRani-mj3hg2 ай бұрын
Thankyou sir for giving a clear explanation 🙏
@AmandeepSinghP19 ай бұрын
thanks brother for very easy understanding of sql joins,it realy helps me to understand joins in sql. 😄
@aadhiyanth59699 ай бұрын
Learnt Python with you, now begins SQL too
@havefun93809 ай бұрын
I love you explanation, thank you mr
@methanesulfonic Жыл бұрын
Than Venn diagram alone single handedly make this topic way easier than it should be. As always, Thank you!!
@yolo-cars Жыл бұрын
Thank you! This video needs more likes!
@darklord6354Ай бұрын
thanks ffor explaining it in simple words
@patatedeoufleretour6 ай бұрын
This video is proof that it doesn't take tons of explanation to understand joins.