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

-- 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;

Great video!

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.

Thanks! You made it so easy.

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.

The best video so far

Your videos are always simple and concise

this is surprisingly easy, I always though it would be harder to understand
thank you

So if we build a code for Inner Join we could adapt the same code for right and left joins.
Perfect.
But for full inner join?

Would be cool if you provided a copy of the database so we can follow along and try it ourselves. thanks for the video!

thx

Thanks for an amazing explanation🙌

Very clear and easy to understand. Thanks!

This explains so clearly with examples provided! Thankyou!

you explained in 5 min where others are taking more 30 min and still not able to explain properly

thanks a lot!

Stunningly simple explanation, considering leaving my girlfriend and dating this content creator

such a simple and easy explanation, thank you!

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

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

so easy , explained very good in only 5min ! Wow thx <3

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

Bro code you're awesome, keep up the good work

What about full outer join

Thanks, bro!

Thank You. Perfect

How many people could detect this was actually an AI voice?

Thanks a lot

Subscribed! You're gifted at explaining things

eeezee peezee lemon squeezee

i love you bro

You helped me a lot during my bootcamp, thanks bro!

now this is a great tutorial man i fell in love XD

i actually hate how easy you made it...i must be stupido

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

Nice & neat ❤

Thanks for this. So easy to understand

Wonderfully clear explanation.

bro ur god ,, i bow to you ,,

Very nice, thanks.

Hello! how about creating a join with 3 or or tables?

I love your Video's you are always street to the point by a simple way thanks alot

Is the Left join is the same as Left outer join?

Thank you for your brilliant explanation ! Not even my college teacher did explain as you do 😂! Thx a lot !!!

Much Appreciated

THANKYOU VERYMUCH!!!

Thank you! This video needs more likes!

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