Chapter 4 Exercise 60

60. List all of the patients (name and phone) seen by Dr. Sanchez in February.

SELECT DISTINCT Employee.LastName, Patient.PatientID, Patient.LastName, Patient.Telephone
FROM (Patient INNER JOIN Visit ON Patient.PatientID = Visit.PatientID)
INNER JOIN (Employee INNER JOIN VisitProcedures
ON Employee.EmployeeID = VisitProcedures.EmployeeID)
ON Visit.VisitID = VisitProcedures.VisitID
WHERE (((Employee.LastName)="Sanchez")
AND ((Visit.VisitDate) Between #2/1/2013# And #2/28/2013#));