Exam objectives in this chapter:
Work with Data
Query data by using SELECT statements.
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:
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 ...