From the course: Learning Microsoft SQL Server 2022

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Join data from multiple tables

Join data from multiple tables - SQL Server Tutorial

From the course: Learning Microsoft SQL Server 2022

Start my 1-month free trial Buy for my team

Join data from multiple tables

“

- [Instructor] Relational databases are able to efficiently store data because they separate information into multiple tables. This reduces redundancy and increases reliability because conflicting information cannot be stored in a properly designed database. To see what I mean, let's take a quick look at the Warehouse.StockItems table from the Wide World Importers database. I'm going to scroll down here and find it there. Let's go ahead and expand it and open up the columns. Here we can see that there are lots of different columns inside of this table. Let's write a new select query that takes a look at a couple of specific columns. I'll grab the StockItemID, StockItemName and SupplierID columns from the table Warehouse.StockItems. Let me execute the statement and we can see the results. Here we see one row for every product that Wide World Importer sells. The Supplier ID tells us who manufactures each item but it doesn't…

Contents