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:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
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.

[@gaybarile4232]

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!

[@SQLServer101]

You are so welcome! I'm glad it helped.

[@hary0198]

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

[@MyAfroBohemianHomestead]

Thank you so much! So easy to understand.

[@nermaw]

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

[@yonatanmesfin8545]

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

[@rizwanrauf9347]

very well explained

[@chishikiendeavourer8663]

Good explanation 👍

[@akshayshelke738]

not running same in my ssms

[@SQLServer101]

Hi Akshay. It should do so. Please check the code and try again. Phillip