Chapter 4 Exercise 39

39. List the manufacturers who supplied mountain bike (MTB) forks in 2010. (2)

SELECT Component.Category, Component.Road, PurchaseOrder.OrderDate, Manufacturer.ManufacturerName
FROM Component INNER JOIN ((Manufacturer INNER JOIN PurchaseOrder ON Manufacturer.ManufacturerID = PurchaseOrder.ManufacturerID) INNER JOIN PurchaseItem ON PurchaseOrder.PurchaseID = PurchaseItem.PurchaseID) ON Component.ComponentID = PurchaseItem.ComponentID
WHERE (((Component.Category)="Fork") AND ((Component.Road)="MTB") AND ((PurchaseOrder.OrderDate) Between #1/1/2010# And #12/31/2010#));