Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

HOUR 7. Building SQL Statements Based on Multiple Tables

Now that you’ve learned the basics of the T-SQL language, you’re ready to move on to more advanced techniques. To really take advantage of what T-SQL has to offer, you must know how to return recordsets that contain data based on multiple tables. In this hour you’ll learn:

• What Join Types Are Available and How to Use Them

• How to Output Data Based on Multiple Tables

• How to Group Your Query Output

• About the Aggregate Functions Available to You

• What the Having Clause Is and When to Use It

• How to Union Data from Multiple Tables

• How to Build Subqueries

By the Way

The examples that follow are based on a database called Northwind which is included on the sample code CD. Instructions ...