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.
This site uses Akismet to reduce spam. Learn how your comment data is processed.