Newbie with coding problems

<i><b>Originally posted by : ejimenez (ejimenez@vivire.com)</b></i><br />Hi, I am testing a script from Instant Asp Scripts, but it doesn't seem to work for me. The error message that appears is:<br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CIMoreInfoRequestDistributees.DistributeeID = CIInterestDistributionList.DistributeeID LEFT OUTER JOIN CIInterests ON CIInterestDistributionList.InterestID = CIInterests.InterestID'. <br /><br />/asp/mail/index.asp, line 84 <br /><br /><br />The code for that section is:<br /><br />DistribSQL = "SELECT CIMoreInfoRequestDistributees.EmailAddress " _<br />& "FROM CIMoreInfoRequestDistributees INNERJOIN " _<br />& "CIInterestDistributionList ON CIMoreInfoRequestDistributees.DistributeeID " _<br />& "= CIInterestDistributionList.DistributeeID LEFT OUTER JOIN " _<br />& "CIInterests ON " _<br />& "CIInterestDistributionList.InterestID = CIInterests.InterestID " _<br />& "WHERE CIInterestDistributionList.InterestID = 0 "<br /><br />I don't know if the problem is the code or the database, please help me.<br /><br />If you need any other info, please let me know.<br /><br />Thanks.<br />

<i><b>Originally posted by : Richard (richard@trinet.co.uk)</b></i><br />You need a space in the second line: "INNERJOIN" should read "INNER JOIN"<br /><br /><br />------------<br />ejimenez at 5/5/2001 11:46:07 AM<br /><br />Hi, I am testing a script from Instant Asp Scripts, but it doesn't seem to work for me. The error message that appears is:<br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CIMoreInfoRequestDistributees.DistributeeID = CIInterestDistributionList.DistributeeID LEFT OUTER JOIN CIInterests ON CIInterestDistributionList.InterestID = CIInterests.InterestID'. <br /><br />/asp/mail/index.asp, line 84 <br /><br /><br />The code for that section is:<br /><br />DistribSQL = "SELECT CIMoreInfoRequestDistributees.EmailAddress " _<br />& "FROM CIMoreInfoRequestDistributees INNERJOIN " _<br />& "CIInterestDistributionList ON CIMoreInfoRequestDistributees.DistributeeID " _<br />& "= CIInterestDistributionList.DistributeeID LEFT OUTER JOIN " _<br />& "CIInterests ON " _<br />& "CIInterestDistributionList.InterestID = CIInterests.InterestID " _<br />& "WHERE CIInterestDistributionList.InterestID = 0 "<br /><br />I don't know if the problem is the code or the database, please help me.<br /><br />If you need any other info, please let me know.<br /><br />Thanks.<br />