Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
April 2002 T-SQL Tutor Project
Apply what you learned about scripting n-table outer joins by completing this homework assignment.
Kimberly L. Tripp
March 31, 2002
1 Min Read
To test this article's syntax, find the commented script file, NTableOuterJoinsExamples.sql, using the "Download the Code" icon. In addition, each article includes a small homework assignment to help you continue to improve your T-SQL syntax. You can find the answers in the NTableOuterJoinsHomework.sql script.
Applying the tools and tips I gave you in this article, write queries that use the Northwind sample database to answer the following questions:
Which customers have purchased beverages? For this query, list the order date, the customer name, and the beverage name.
Change the query from Question 1 to show all beverage products regardless of whether they've been ordered. Does the number of rows in the result set change? Why or why not?
About the Author(s)
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
_(1).png?width=700&auto=webp&quality=80&disable=upscale)
.png?width=700&auto=webp&quality=80&disable=upscale)