SQL: Understanding the JOIN clause in the SELECT statement

[@jonathanzuniga3681]

I just had an instructor spend 2 hours trying to explain this. Thank you Mr Fudge!

[@borislavkamenov366]

Definitely the best explanation of SQL Join in the Internet. Thank you, bro!

[@smackie001]

The first video to explain the ON clause. Thank you!!

[@KeniGid]

Splendid job, Mr Fudge. You rock!

[@victorross8045]

Hello Michael. I taking a Master's level course in SQL. I did not understand joins at all until I viewed your video. Thank you!

[@echosystemd]

Simple yet elegant explanation. Thumb up.

[@rocker11742]

With your help I am survivng my POS/410 class. Thank you.

[@AjayKagitha]

Michael, you're excellent. I love the way you explained. Keep up the good work.

[@michaelfudge]

You're welcome! I'm glad you're finding these useful...

[@BeingABeing]

best and easiest explanation of joins I've been able to find. ty

[@aks3479]

Simple, Short and Precise explanation.
Thanks for video

[@Keontez24]

Thank you for keeping it simple and easy to understand. Great Video!!!!

[@pavansantos]

the best way to explain joins.

[@KracNelly]

You are amazing!!!! I so much like your simple ways to teach.

[@TedEthio]

Excellent! To the point! Worth every minute!

[@electro46475]

Because a simple "like" is not enough, Thank you so much!

[@michaelfudge]

St Tomas You're welcome!

[@mafakka2]

does it work in 2016 same way?

[@rsz90182]

You can always try and find out.

[@sreeramvalavala506]

Thanks for giving us clarity with comparison Michael.. :)

[@Jstar141957]

Great illustration... I understand it much better!

[@aureliojargas]

Excellent! For the first time I really understood all this mess. Thank you!

[@bbanno123]

This was very clear and addressed my confusion. Thanks so much Michael!

[@fico455]

You taught me more than our teacher did during the whole semester. Thank you so much.

[@jessieboswachter]

Hey Michael, thank you for this short and great tutorial.

[@inrito2007]

Thank you so much for sharing your knowledge, it is truly valued and greatly appreciated! I’m new to SQL but have crystal report background and these videos have really helped start in the right direction!...>Again, thank you so much for your time!

[@tails_zero]

Seriously thank you for this, Michael.

[@7heFatman07]

Thanks a lot, this is way better than the we got at the University :D

[@purnimadas3762]

Thank you Michael, simple concepts and so well explained. Thanks once again!

[@kj-marslander]

you summarized a 30 page chapter into 10 fun minutes. Thanks.

[@arjunchakravarthy8457]

thanks a lot Mr.Michael Fudge

[@BlueKalue]

Thank you! I couldn't understand this just by reading. Really helpful having an example.

[@michaelfudge]

You are welcome!

[@pedrojmanuel]

Hi Michael,
Can you exlain when you need to do a sub query select clause in a Join . I have a big confusion with this kind of groups... what is need for!
tks

[@spp2000]

fantastic explanation...I follow the 89 syntax only your video helps a lot...god bless you

[@daryldyehouse6404]

Thank you for your wisdom!

[@BensometimesGIS]

thanks, straightforward and works

[@3765alaye]

Mucho gracias for the detail and clear explanation on joints

[@lb9017]

Great! I was looking for something like this! thx

[@kustar845]

Thank you very much Michael! great simple tutorial!

[@johnhio1843]

You made it simple, thanks a lot sir.

[@theFlyingUnderpants191]

thanks man! and great tutorial... its going to get me through my DBMS paper tomorrow! :)

[@ejoaquinhuertas]

Thank you Michael! This does "clear the muddy waters" on SQL joins

[@ejoaquinhuertas]

***** Thanks. I just added it to my favorites.

[@daadylomax]

very helpful and precise....thank you!

[@liuhc]

Saved my day, thank you!

[@Darkness93]

This was brilliant! Cleared it all up for me, thanks :)

[@DoctorDARKSIDE]

Nice one, very well explained!

[@GeorgeUK84]

Hey Michael, are you aware that this video is used as course material at the graduate level at Central Michigan University?

[@michaelfudge]

I am now! Very cool!

[@GunjanGrunge]

very well explained

[@FranciscoAndres27]

Awesome! thank you I finally get it!

[@pop-cornfuelsllc7924]

Hey Michael, great tutorial. Are there any transcripts available for basic SELECT and JOIN clause?

[@jhormanrodriguez1377]

a big thanks from colombia

[@michaelfudge]

Because you cannot query more than one table and combine the results into a single output without a join.

[@mypcissues]

thanks so much really nice to understand

[@mathejoh]

why is that "join" greyed out? 1:53

[@michaelfudge]

It's a keyword

[@michaelfudge]

Thank you.

[@sanjutsi]

Thanks, very clear!

[@bflance]

awesome videos!
helps alot.

[@victoriakim923]

Thanks a lot for clear explanation! Great video:-)

[@ComandanteJ]

Excellent explanation.

[@kennycelt]

Very nice, Thank you.

[@itsdannyftw]

Excellent video :D

[@Chaniity]

it really helps me, Thank you so much Sir!

[@pathless_path_hindi]

clear explanation! thanks!

[@naharulhayat]

you are the best...thank you very much

[@mksktube]

Nice and Easy. Thank you.

[@Thona-KH]

Thank you so smuch for your video it help me a lot....

[@negromaldito]

Thank you! very clear

[@bflance]

Thanx for the reply Michael! :)
I will rephrase my question:
Now i do know why i need JOINs yet, the problem i have here is following:
i have several tables, one for emails one for user and one for salaries (for example..)
i want to delete all users that have in their email address (at)domain.com..
i would expect to use "join" query to get list of such users than then delete,it doesnt work.
i cant understand how to use JOIN to make delete from all tables all info of users searched.
on SQLite3.

[@chandu309]

nice explanation...thnk u very much..

[@chrison87]

Thanks for the great video...!

[@CarlosGarcia-bj2py]

Thank you, great video.

[@hadireg]

Awesome! Thanks sir!

[@dthpunch666]

thanks for the tutorial.. really helpful :)

[@RedBlade32]

Nice voice to listen to

[@kakhitv587]

Good Video Thanks alot

[@vatodeth]

THANKS!!!!

[@jghanesh]

Thanks so much

[@michaelfudge]

When you use a SELECT in the FROM clause, it must be aliased and it treated as if it were a table or view for example:
SELECT a.customer_name FROM ( SELECT customer_name FROM customers ) a
Its more difficult to answer WHY you'd need to use this pattern. Perhaps I should explain in a future video :-)

[@RatherBAnon]

Here's hoping Mr. Fudge goes on to outclass Jordan in basketball. Thanks for the great tutorial!

[@michaelfudge]

Rather B. Anon Me too, but given my short height and poor dribbling skills, I'm confident a 75 year-old Jordan would crush me 1 on 1. :-)

[@bflance]

nice video, but couldnt understand anything..
what are joins? why do we need them???

[@dmitryck]

very good.. thanx

[@swamysasank]

Thanks Brother

[@LoldemortII]

finnaly got it. thanks ;)

[@n70amu]

thank you soo much sir

[@DineshSharma-fz3wr]

great vedio sir

[@AshishPatil03]

nice example

[@charithananayakkara7]

thanks u very much

[@yesehakesolomon4763]

Awesome!!!

[@giourumashvili]

where is natural join?

[@Hernaner28]

you missed the natural join

[@231doughboy]

A+

[@jovanpetkoski530]

I created a repo with all the queries and notes from this series. Someone might find it useful: github.com/Petkoski/mf-learn-ms-sql-server

[@tien4930]

CAPTAIN FUDGE

[@ganeshkumarsiva176]

Thanks a lot

[@ArslanAlihanafi]

Thank you.