MySQL SELF JOINS are ... ughhh

#MySQL #tutorial #course
00:00:00 example 1
00:05:44 example 2
00:00:00 conclusion
SELECT a.first_name, a.last_name,
CONCAT(b.first_name," ", b.last_name) AS "reports_to"
FROM employees AS a
INNER JOIN employees AS b
ON a.supervisor_id = b.employee_id;

[@BroCodez]

SELECT a.first_name, a.last_name,
CONCAT(b.first_name," ", b.last_name) AS "reports_to"
FROM employees AS a
INNER JOIN employees AS b
ON a.supervisor_id = b.employee_id;

[@israelrodriguez331]

Your explanations are on point. My professor is pretty much like “Figure it out yourself, look at the PPT” SMH.

[@MrTekniqs]

Most of my college education right here. “Hey guys we’re going to learn Java. Here’s a piece of paper with some code. I’m a math teacher good luck.”

[@valerioharvey7289]

Damn. We really pay a shitty amount of money just for the professor to tell us to study ourselves ​@@MrTekniqs

[@MrBicholino]

Best self join explanation I've found so far. 10/10!!!

[@jina5920]

You're the best teacher ever !!!! I really appreciate your work for us!!!

[@iradaska]

Bro thank you! I have been struggling a whole week to understand self joins!! All clear now ❤

[@joe-hd3uv]

Dude this was so incredibly helpful. Thank you!

[@dankprogrammingmemes7807]

Thanks a ton for making this series! Subbed!!

[@patrickkahng2274]

Excellent and clear explanation about self-join. 👍👍 Thank you very much.

[@redhulkinator]

Thank you! I have been reading through the material in my Data Management course and I was completely confused. Now I understand what they are doing!!!

[@hemanthmonu9902]

10 mins just flew away
With excellent teaching ❤

[@sarah-mikal]

best self join explaination i've gotten in 9 months

[@ubaidullah6744]

Its a great video easy to understand Thank you, some people over explain things that makes it over complicated but after watching this video it looks pretty simple now.

[@niru216]

Thanks! joins were pain until I found you

[@Lulu-ck3ji]

a chad in explaining. Thanks much!

[@omega_sine]

I never knew Mrs. Puff’s first name was Poppy 🤯

[@Lulu-ck3ji]

same lol

[@methanesulfonic]

I'm pretty sure my teacher will somehow over-complicate this course if they ever teach this lol.

[@beckybioh8695]

Bro, can you do an Oracle DBMS series too😍...your videos are life savers! God bless you!

[@johnvak7390]

thank you for explaining!

[@riasingh11]

best video on self join

[@ShaikMoAbdullah]

This was awesome. Thank you

[@Blujay188]

EXCELLENT EXPLANATION ! thank you

[@edwardtattersfield3033]

Bro, nice vid. ONE QUESTION! What keyboard shortcut are you using to track to the beginning of a word? As you have done it makes more sense for me to type the column and THEN the table even though sql syntax requires this info in the opposite order. The shortcut would make it easier - i cant find it online.🙏

[@justinprice1929]

He's probably using Ctrl+'any-arrow-key' for PC, and it would be Command+'any-arrow-key' for Mac.

[@chngdexter2008]

Your explanation is awesome!

[@aayushregmi4334]

You're the best tutor

[@callofdutymlgversion910]

truly and bro coder appreciate it bro

[@mohammeddanish8624]

a tons of thanks!

[@dolodoowop1971]

SO helpful.. thank you !

[@Imoqine]

I knew from the title (self joins are...ughhh) 😆 it's not as usual.

[@MaedehDehghan-vx6hx]

that was practical. thanks

[@bernasiakk]

super easy and helpful

[@ExiltedOne]

thank you that was great!

[@hiwab41]

nice BRO!

[@k.chriscaldwell4141]

Thank you.

[@CodeWithDF]

u are great but can u do tut for website full course

[@vishwanathchintala2000]

you are amazing

[@PhrontDoor]

Let's be honest.. Krabs isn't gonna comp ANYONE a free meal.

[@nikoprieto1]

How can i change my screen to see the same way you do?
Pleaseeeee.
Thanks for your video!

[@mezomezo8718]

I have a question which making me not getting this whole self join thing why couldn't we refer our join condition on table A customer ID =table 2 manager ID why did we have to refer to the foreign key of the first table instead of the primary key.your answer is greatly appreciated.

[@muratemredemircioglu2897]

i am a beginner... We have to create employee ids such a way that when we write the code, it has to point the correct way right? I mean what if we made Mr. Squidward's employee id 6?

[@AnshuMeena-g5x]

Thanks Bro

[@princeakinolaoluwagbemigag1750]

Top 10

[@mehavenothing7078]

i want to ask a question, why after we use the inner join, on a.supervisor_id = b.employees_id; the sandy name will repeated a few times, i still didnt get why

[@FilipRamčić-g8j]

Because she is a supervisor of multiple people. You're looking at each row of the left table and see who is the supervisor for each employee in that table which is Sandy except for Sandy herself. Her supervisor is Crabs.

[@memezthug1507]

bro need full join also bro please.........

[@tsunningwah3471]

bilibili

[@PythonicMind]

First

[@alphaomegathegreatest7948]

Jesus Christ was lifted in the cross to pay for our sins, everyone who believes in him shall have eternal life John Cap. 3 | NIV-EN
14 Just as Moses lifted up the snake in the wilderness, so the Son of Man must be lifted up,
15 that everyone who believes may have eternal life in him.”

[@MubarakAli-qs9qq]

Best ever explanation sir thanks alot

[@MubarakAli-qs9qq]

Share this vedio plz