Chapter 4 Exercise 10

10. List the adoption groups with phone number who placed cats in October.

SELECT AdoptionGroup.AdoptionSource, AdoptionGroup.ContactName, AdoptionGroup.ContactPhone, Sale.SaleDate, Animal.Category
FROM Sale INNER JOIN (AdoptionGroup INNER JOIN Animal
ON AdoptionGroup.AdoptionID = Animal.AdoptionID) ON Sale.SaleID = Animal.SaleID
WHERE (((Sale.SaleDate) Between #10/1/2013# And #10/31/2013#) AND ((Animal.Category)="Cat"));