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: [ Ссылка ]
98-364: Database Fundamentals (Microsoft SQL Server): [ Ссылка ]
70-462 SQL Server Database Administration (DBA): [ Ссылка ]
Microsoft SQL Server Reporting Services (SSRS): [ Ссылка ]
SQL Server Integration Services (SSIS): [ Ссылка ]
SQL Server Analysis Services (SSAS): [ Ссылка ]
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): [ Ссылка ]
----
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.
