From the course: Querying Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding JOINs

Understanding JOINs - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2012

Start my 1-month free trial

Understanding JOINs

Up until this point we've taken a look at splitting our tables out into multiple tables through the use of normalization in our database. Knowing that our tables contain related information there has to be a way for us to get that information back from these related tables into a single result set. We talked about the ability to use the primary keys and foreign keys to join those tables or to bring that data into the relationship. And we're going to take a look at the JOINS here and how we go through the process of joining our tables in our database. The JOINS are used to create that single result set of records from those multiple tables. And because most of you are relational database management systems use normalization and split that table into multiple tables. These JOINS will be required to get your queries to extract the appropriate data from the different tables in the database. So, when we look at the concept of a JOIN essentially it's the mechanism that tells SQL which…

Contents