From the course: Querying Microsoft SQL Server 2019
Join today to access over 25,600 courses taught by industry experts.
Inner joins - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2019
Inner joins
- [Instructor] The inner join is the most common table join type that you can make in SQL server. It returns records that have matching data on both sides of the pair of tables. Let's take a look by first exploring the data that can be found in the person table and the person phone table in the AdventureWorks database. Both of those can be found inside of the person schema. Here's the person.person table and the person.person phone table. I'll write two select queries to take a look at the raw data that we have to work with. The first one we'll select the business end of the id first name and last name from the person.person table. And the second one we'll select the business end of the id and phone number from the person.person phone table. When you execute this query, it returns two different result sets. The first one displays the results of the first query against the person table. And the second one down here at…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.