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 ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
