FIT 100
© Copyright University of
Washington 1999-2000
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));