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));
Previous slide
Next slide
Back to first slide
View graphic version