Joining Tables Together
SELECT DISTINCTROW Visits.TrackingNum, Visits.DrugR,
   Clients.FirstName
FROM Clients INNER JOIN Visits ON Clients.ClientID = Visits.ClientID
WHERE (((Visits.TrackingNum)<>"") AND ((Visits.DrugR)=Yes));