Join data from multiple tables SQL Server


show more You can enhance the usefulness of data grouped in your SQL Server by joining data from multiple tables in your SQL Server. This training video describes advanced skill techniques for taking organized data from more than one table and defining relationships to further sort information into useful groupings. show less
please wait ...

Joining data from multiple tables

So going from the end of the last example, we have some grouping going on here, but it's not as useful as it could be. So if I were to look at the underlying table definition, the issue that we have is when we are looking at the information for any particular product we are getting a name--say, Water Bottle, 30 OZ--but we are also getting this ProductCategoryID. It's just a number, 32. And what we want to do is take it to a separate table, ProductCategory, where we can take that number of 32 and actually get the name of the category, in this case Bottles And Cages.

Well, the great thing is, as long as there's a proper relationship defined in the database--and there is here--it's very easy for us to focus on what we want, which is the name of the product and the name of the category. And actually, in this case, we can let Report Builder pretty much figure everything else out. So back in Report Builder, I'm going to switch back into Design view. And really what I want to ...

Joining data from multiple tables
Video duration: 4m 33s 3h 44m Advanced

Viewers:

You can enhance the usefulness of data grouped in your SQL Server by joining data from multiple tables in your SQL Server. This training video describes advanced skill techniques for taking organized data from more than one table and defining relationships to further sort information into useful groupings.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...