The different types of JOINs in Microsoft SQL Server - INNER, LEFT, RIGHT, FULL and CROSS

Following on from last week's video, we will join two tables together.
Want more? My SQL Server Udemy courses are:
----
In this video, we're going to learn about the different types of JOINs in Microsoft SQL Server. We'll discuss INNER, LEFT, RIGHT, FULL and CROSS JOINs, and how each one works.

If you're working with SQL Server tables and want to know how to best join data, then this video is for you! By the end of this video, you'll have a clear understanding of all the different types of JOINs and be able to use them to your advantage.

There are five different types of JOINS:
1. The INNER JOIN - this is the default JOIN. Only those rows in the two tables which match.
2. The LEFT JOIN - all of the left-hand table rows with only those in the right-hand table which matches.
3. The RIGHT JOIN - all of the right-hand table rows with those in the right-hand table which matches.
4. The FULL JOIN - all of the two table rows, taking account of matching.
5. The CROSS JOIN - all of the first table's rows against all of the second table's rows. This multiplies the two tables' rows, has not account of matching, and therefore is not often used.

[gaybarile]

Thank you so much for this. I have watched other videos before but your explanation is the best. I have struggled to wrap my head around these join concepts for the longest time and finally I can say that I fully understand these now thanks to you. You are a fantastic teacher!

[hary]

great explanation even for me that already works many years, it's good to refresh my memory

[yonatanmesfin]

People might not choose this because of low views but this is well explained thanks

[nermaw]

this the best video for join in SQL thank you very much for the effort .

[MyAfroBohemianHomestead]

Thank you so much! So easy to understand.