Advanced Query Exercise Chapter 5 Use Northwinds mdb
Advanced Query Exercise Chapter 5
Use Northwinds. mdb Order Details Table
1. Find Duplicates w Order Details table w Use the Query wizard to find duplicates of the Product/Product. ID field Pg. P MIS 342 Exercises 3
1. Criteria w Examine the resulting criteria w In (SELECT [Product. ID] FROM [Order Details] As Tmp GROUP BY [Product. ID] HAVING Count(*)>1 ) w What other way could you have accomplished this task? Pg. P MIS 342 Exercises 4
2. Find Unmatched w Order Details Left Outer Join to Orders w Use the Query Wizard n Output all Order Details records Pg. P MIS 342 Exercises 5
2. Criteria w Examine the resulting criteria w Why are no records returned? Did we do something wrong? Pg. P MIS 342 Exercises 6
Customers Without Orders w Northwind Database w Customers and Orders tables w Customers. Company. Name w Orders. Order. ID w Which customers have not placed orders? Pg. P MIS 342 Exercises 7
Customers Without Orders Pg. P MIS 342 Exercises 8
Orders Without Customers w Northwind Database w Customers and Orders tables w Customers. Company. Name w Orders. Order. ID w Which orders are not associated with a customer? n Note: Enforce referential integrity was turned off in relationships, then a customer was deleted Pg. P MIS 342 Exercises 9
Orders Without Customers Pg. P MIS 342 Exercises 10
- Slides: 10