From the course: Querying Microsoft SQL Server 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Left, right, and full outer joins - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2019
Left, right, and full outer joins
- [Instructor] The three outer join types all retrieve the same roles as an inner join, plus some additional roles that an inner join would exclude. Let's create a new query and I'm going to select some information out of the person table from the database. I'm going to pull out the business entity ID, person type, first name, and last name columns from the person dot person table. When I execute the query, I get 19,972 rows returned, and these are all the different people that are in that table. Some of these people are employees of Adventure Works, but not all. Other people are subcontractors or general contractors or independent consultants for Adventure Works. There's a lot of different kinds of people in this database table. We can execute another query against the human resources dot employee table to find out information that's specific to the employees. This time I'll select the business entity ID and job title…
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.