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:
• How to Output Data Based on Multiple Tables
• How to Union Data from Multiple Tables
• How to Build Subqueries
The examples that follow are based on a database called Northwind which is included on the sample code CD. Instructions ...