Joins | SQL | Tutorial 17

[@williamhunt8313]

I don't know why you don't have more subscribers. I have been using RUclips for computer science help for many semesters. You are the best, for real!

[@AndyRyanTX]

I'm usually to lazy to comment on videos, but I just jumped in here to say thank you for making this easy for your viewers. This subject can be complex for newbs and I always appreciate instructors who are empathetic to how people learn. Great job!

[@williamhunt8313]

I've been reading my textbook for hours trying to understand joins. Now I get it. Mike, you are AWESOME!

[@tysonhamada6527]

great work you clear all my concepts about joins and difference between left and right join thanks man you are doing great work keep making great videos

[@pavanakumarpk2525]

Chirambu

[@jn01996]

What happens if I have more than 2 tables? Which one of them would be right and left then?

[@mahinhossen4251]

We can implement full outer join in MySQL using **LEFT JOIN UNION RIGHT JOIN**
SELECT employee.emp_id, employee.first_name, branch.branch_name
FROM employee
LEFT JOIN branch ON employee.emp_id = branch.mgr_id
UNION
SELECT employee.emp_id, employee.first_name, branch.branch_name
FROM employee
RIGHT JOIN branch ON employee.emp_id = branch.mgr_id
WHERE employee.emp_id IS NULL;

[@chandlerzhu9735]

Can I write'ON branch.mgr_id = employee.emp_id' instead of 'ON employee.emp_id = branch.mgr_id' ?

[@cn19111]

Sure, you can write

[@TheUmbowa]

hi do you have a tutorial on self joins?

[@ibnbattuta1304]

It looks like when you did LEFT JOIN, your new table is sorted by branch_name. I downloaded the latest MySQL, and both the Workbench and PopSQL sort the emp_id instead. No biggy I guess.

[@th3j0t46]

An inner join is equal to a regular join? Did not quite understand that

[@HiruniAbeysekara-fl1ij]

Great ❤ good luck sir 🎉🎉🎉

[@oguerimiracle3444]

Please what is Relational Algebra

[@curryrice7510]

YOU DESERVE MORE RECOGNITION AND SUBSCRIBERS!!! Thank you for your videos!

[@serefsendil]

thank you Mike! So helpful videos. BTW all that names :) I believe you love The Office :)

[@eyobh7414]

bro u just made it easier thanks

[@shamkentemirgaliyev8549]

Thank you! Awesome!

[@fleurrubbani7104]

You are amazing!!!! I have been struggling for hours to get joins and after 10 mins of watching this tutorial I get it. Thank you Mike.

[@aryanshmahato]

God! It was so easy to understand.. I was scared of joins in SQL before this video.. Thanks alot

[@tysonhamada6527]

thanks man keep it up

[@breakthecode8323]

You teach incredibly, thanks 🙏

[@deepas3680]

I have one doubt that after combining the table, will it appear as new table or changes are made in that particular table

[@daniilpogolovkin8221]

thanks!

[@jagrutnimmala6087]

You are doing a great job !! thank you so much.

[@k.chriscaldwell4141]

Superb! Thank you.

[@malechas2174]

Mike, again top tutorial.

[@gabriel7924]

Thank you so much for this

[@olgaolga4843]

Thanks Mike, a great explanation!

[@sonamuhialdeen7866]

Amazing tutorial

[@salitotakhel3824]

THANK U

[@Cognitoman]

Thank you

[@pavanakumarpk2525]

RM