Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Chapter 4. Combining Sets

Exam objectives in this chapter:

• Work with Data

  • Query data by using SELECT statements.

  • Implement sub-queries.

• Modify Data

  • Combine datasets.

T-SQL provides a number of different ways to combine data from multiple tables; this chapter describes the different options. The chapter covers joins, subqueries, table expressions, the APPLY operator, and set operators.

Lessons in this chapter:

• Lesson 1: Using Joins

• Lesson 2: Using Subqueries, Table Expressions, and the APPLY Operator

• Lesson 3: Using Set Operators

Before You Begin

To complete the lessons in this chapter, you must have:

• Experience working with Microsoft SQL Server Management Studio (SSMS).

• Some experience writing T-SQL code.

• Access to a SQL Server 2012 instance with the sample ...