O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required