&nbsp;<BR>I have been trying to create a SQL statement and can&#039;t figure it out. I am trying to relate a table that has a primary key(OrgID) with a table the has composite key (OrgID, SurveyID). Here is my SQL statement:<BR><BR>SQL = "SELECT Email, OrgID FROM OrganizationInfo Inner Join SurveyResult on (SurveyResult.OrgID=OrganizationInfo.OrgID) where SurveyResult.SurveyId &#060;&#062; " & Request.Form("SID") <BR><BR>This query includes emails that are related to the correct OrgID but not the correct SurveyID...Any Ideas??