SQL Server Queries Part 6 - JOINS (Inner and Outer Joins)

By Andrew Gould

This tutorial can be seen in written form at:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[glenrietveld]

As always, nice and clear explanations with NO complicated queries for examples.

[santanawales]

I must acknowledge that the best illustration of JOINS I have seen is this video. Venn diagrams were super useful. Now I know exactly what to expect when I use JOINS.
Thank you WiseOwlTutorials for sharing these videos. Much appreciated.

[kwijaeboner]

My database administration professor couldn't explain joins in a way that I understood, but you have helped me understand the concepts much firmer! Thank you so much! You have a great talent for teaching

[belegend]

Brilliant, Brilliant, Brilliant stuff Andrew.

All you folks watching should also understand that learning basic set theory will give you a MUCH deeper understand of the SQL language.

Thank you Andrew!

[hunnydarling]

The best YouTube tutorial, SQL,reporting services, very good

[jeffreyjhouser]

Another superb video and explanation of a somewhat complex part of SQL and queries. One of the best lessons I found when looking for this information, including a chapter in an expensive book I own about this subject!

[youngcolt]

The illustration of Left and Right Joins with Venn Diagrams.... awesome!

[SaqibNaveed]

For such a long time I coudn't understand joins... This single video made complete sense of Joins for me. Thank you :) your teaching method is awesome

[vec]

Seems that JOIN is a complicated concept but the visuals made it very simple.
Thank you again

[giselledarlene]

Thank you! Really enjoyed this video and it helped me understand joins better than other videos / articles I've previously read.

[forpoopsandgiggles]

You are truly awesome. These tutorials have helped me sharpen my "proc SQL" skills on SAS. Thank you so much

[ilegolord]

Really easy to follow and very clear instructions, thank you so much for putting these tutorials for all types of audience. Great job and 'Thank you" again.

[fissehaberhane]

Your tutorials are much better than an edX course I am taking. You explain concepts very nicely. Great thanks!!

[a-iboom]

to be honest i haven, t learned much in the whole semister that i learned through out your videos. thank you

[Goodborni]

Hey there wiseowl, I see the positive relation you have with the people who watch your videos and how quickly you reply, it's really touching.
I got an 2 part test about Databases in my college, I completed the first one, now I am preparing for the second part of it, which is about SQL only, and I had a hard time understanding all of the topics mentioned in your videos, thanks to your series though not only did I fully understand all of it, but I also really enjoyed learning all of it.

I was thinking of saying thanks at the last of the SQL episode to so to say wrap it up, but I was scared I might forget. So I just did it here.
Once again Thank You very much God Bless you and your family.
Thanks for all your hard work, trust me it is appreciated a whole lot, as you probably have noticed by all the positive feedback you get.

Peace

[techconnectlearning]

You are awesome. One of the best youtuber and tutor. Your video always help to enhance my technical skills. Lots of love from India. God bless you always..

[Tmyster]

God bless you! Very clear and concise. Really really appreciate your time putting all of these videos together!

[mweaton]

Fantastic set of tutotials! I have just landed a new job and was a bit unsure about my abilities but these tuts have put my mind at rest. Many thanks!

[mejab]

probably I lost 2 years at university trying to understand this lesson, but here I am thank you

[Desp]

U are indeed a wise owl! The venn diagrams greatly facilitated my learning, thank you!