gistfile1.sql

SELECT     dbo.tblResearchDyads.ResearchID, dbo.tblResearchDyads.TherID, dbo.tblResearchDyads.InTX1, dbo.tblResearchDyads.OutTX1, 
                      dbo.tblResearchDyads.dyadid, dbo.tblResearchClients.Condition, dbo.tblResearchDyads.Experience, dbo.tblResearchDyads.clinicalexperience, 
                      dbo.tblResearchDyads.degree, dbo.tblResearchDyads.degreeyears, dbo.tblResearchDyads.endreason, dbo.tblResearchDyads.supervisorid, 
                      dbo.tblResearchDyads.Training
FROM         dbo.tblResearchDyads INNER JOIN
                      dbo.tblResearchClients ON dbo.tblResearchDyads.ResearchID = dbo.tblResearchClients.ResearchID
WHERE     (dbo.tblResearchClients.AIN < 3) AND (dbo.tblResearchClients.Study = 16)