SQL: Understanding the JOIN clause in the SELECT statement

THIS VIDEO HAS BEEN UPDATED! • Master the SQL SELECT ...
Check out the entire Learn Databases Playlist:
• Applied Database Manag...
This screencast introduces table joins, including differences between SQL 89 and SQL 92 join syntax. The various join types such as natural (inner) joins and left/right/full outer joins, and cross joins.

[@jonathanzuniga3681]

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

[@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.

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

[@aks3479]

Simple, Short and Precise explanation.
Thanks for video

[@kj-marslander]

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

[@michaelfudge]

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

[@rocker11742]

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

[@fico455]

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

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

[@pavansantos]

the best way to explain joins.

[@echosystemd]

Simple yet elegant explanation. Thumb up.

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

[@sreeramvalavala506]

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

[@BeingABeing]

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

[@michaelfudge]

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

[@ejoaquinhuertas]

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

[@ejoaquinhuertas]

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

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

[@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 :-)

[@7heFatman07]

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

[@Jstar141957]

Great illustration... I understand it much better!

[@BlueKalue]

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

[@KeniGid]

Splendid job, Mr Fudge. You rock!

[@aureliojargas]

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

[@michaelfudge]

You are welcome!

[@spp2000]

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

[@AjayKagitha]

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

[@arjunchakravarthy8457]

thanks a lot Mr.Michael Fudge

[@Keontez24]

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

[@bbanno123]

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

[@TedEthio]

Excellent! To the point! Worth every minute!

[@purnimadas3762]

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

[@jessieboswachter]

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

[@KracNelly]

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

[@BensometimesGIS]

thanks, straightforward and works

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

[@daryldyehouse6404]

Thank you for your wisdom!

[@tails_zero]

Seriously thank you for this, Michael.

[@pop-cornfuelsllc7924]

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

[@3765alaye]

Mucho gracias for the detail and clear explanation on joints

[@lb9017]

Great! I was looking for something like this! thx

[@jhormanrodriguez1377]

a big thanks from colombia

[@theFlyingUnderpants191]

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

[@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.

[@daadylomax]

very helpful and precise....thank you!

[@GunjanGrunge]

very well explained

[@kustar845]

Thank you very much Michael! great simple tutorial!

[@johnhio1843]

You made it simple, thanks a lot sir.

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

[@chandu309]

nice explanation...thnk u very much..

[@Darkness93]

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

[@mypcissues]

thanks so much really nice to understand

[@mathejoh]

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

[@michaelfudge]

It's a keyword

[@FranciscoAndres27]

Awesome! thank you I finally get it!

[@sanjutsi]

Thanks, very clear!

[@giourumashvili]

where is natural join?

[@liuhc]

Saved my day, thank you!

[@kennycelt]

Very nice, Thank you.

[@bflance]

awesome videos!
helps alot.

[@DoctorDARKSIDE]

Nice one, very well explained!

[@Hernaner28]

you missed the natural join

[@itsdannyftw]

Excellent video :D

[@victoriakim923]

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

[@michaelfudge]

Thank you.

[@Thona-KH]

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

[@Chaniity]

it really helps me, Thank you so much Sir!

[@ComandanteJ]

Excellent explanation.

[@DragonBallZFanOver9000]

Thanks Michael!

[@jghanesh]

Thanks so much

[@naharulhayat]

you are the best...thank you very much

[@mksktube]

Nice and Easy. Thank you.

[@vatodeth]

THANKS!!!!

[@phpnepal]

clear explanation! thanks!

[@chrison87]

Thanks for the great video...!

[@kakhitv587]

Good Video Thanks alot

[@RedBlade32]

Nice voice to listen to

[@negromaldito]

Thank you! very clear

[@dthpunch666]

thanks for the tutorial.. really helpful :)

[@CarlosGarcia-bj2py]

Thank you, great video.

[@dmitryck]

very good.. thanx

[@hadireg]

Awesome! Thanks sir!

[@swamysasank]

Thanks Brother

[@AshishPatil03]

nice example

[@n70amu]

thank you soo much sir

[@DineshSharma-fz3wr]

great vedio sir

[@LoldemortII]

finnaly got it. thanks ;)

[@yesehakesolomon4763]

Awesome!!!

[@charithananayakkara7]

thanks u very much

[@231doughboy]

A+

[@tien4930]

CAPTAIN FUDGE

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

[@ganeshkumarsiva176]

Thanks a lot

[@ArslanAlihanafi]

Thank you.