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