Selecting Data from Multiple Tables.

Selecting from Multiple TablesSelecting from Multiple Tables

The third video in this series is on Selecting Data From Multiple Tables. You can extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database by using join statements. We discuss Inner and Outer Joins and how they are fundamental to getting maximum value from a relational database engine. We start with an introduction to relationships and joins with a look at the differences between a parent and child table. You’ll learn how to define rows in two tables to correspond to each other through a common value column, or through a set of such columns held in common in both tables. The examples show that such relationships can record and store a wide variety of master-detail data points such as the line items in a customer order. 

Be the first to comment on "Selecting Data from Multiple Tables."

Leave a comment

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.