MySQL SELF JOINS are ... ughhh 

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;

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

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

Thanks a ton for making this series! Subbed!!

Dude this was so incredibly helpful. Thank you!

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

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.

a chad in explaining. Thanks much!

thank you for explaining!

This was awesome. Thank you

EXCELLENT EXPLANATION ! thank you

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

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

Your explanation is awesome!

Thanks! joins were pain until I found you

truly and bro coder appreciate it bro

thank you that was great!

SO helpful.. thank you !

nice BRO!

best video on self join

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

that was practical. thanks

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

you are amazing

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

Thanks Bro

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.

super easy and helpful

Top 10

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?

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

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

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

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

bilibili

First

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.”