From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Query information from related tables

Solution: Query information from related tables - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

Solution: Query information from related tables

“

- [Instructor] In this challenge, we need to combine records from multiple tables for a regional library. And the goal is to get a reverse chronological list of borrowing history and show every member, even the ones that haven't yet borrowed any books. I'm going to start just by taking a look at the three tables that were given. We have one called Members, and I'll just select everything out of that table, that gives me the member ID. This is the primary key for the table, and we get the member's name and their email address. Let's take a look at the Books table now. This one also has a primary key column here for the book ID, and we have the name of the book, as well as the author of the book. And then we can get the borrowing history from the Loans table. This one has a primary key for the loan ID. And then we have two foreign key columns that relate back to the Books table here and the Members table with this column. And we'll finally have the loan date. So this is the date that…

Contents