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

#MySQL #course #tutorial

00:00:00 intro
00:01:46 INNER JOIN
00:03:48 LEFT JOIN
00:04:20 RIGHT JOIN
00:04:45 conclusion

-- INNER JOIN selects records that have a matching key in both tables.
SELECT *
FROM transactions INNER JOIN customers

-- LEFT JOIN returns all records from the left table
-- and the matching records from the right table
SELECT *
FROM transactions LEFT JOIN customers

-- RIGHT JOIN returns all records from the right table
-- and the matching records from the left table
SELECT *
FROM transactions RIGHT JOIN customers

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

[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?

[Metro]

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

[Vishwas]

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

[siyabongagift]

Bro you just made it look easy, you the best

[TheLrdOfTheStrings]

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

[christophergruendell]

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!

[oussKhayi]

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

[markbarton]

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.

[MohitYadav-beju]

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

[aikasal]

BRUH, YOU MADE IT MUCH MORE EASIER FOR
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.

[ReneAshu-fbfd]

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.

[celestes]

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!

[thomasbrablec]

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!

[AymanAli]

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

[josephwinstead]

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

[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

[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!

[stevenvillarreal]

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

[PedroHoffmann]

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