Open Recordset Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.. SELECT COUNT(*) AS NoResults FROM tblXML WITH (NOLOCK) INNER JOIN tbl807C39564AEC41EA8D732264543C6A4D WITH (NOLOCK) ON tbl807C39564AEC41EA8D732264543C6A4D.RecordID = tblXML.ID AND tbl807C39564AEC41EA8D732264543C6A4D.fldF8E18C642B4D44608AEBC2F6BB8DDD6D = '{F8ABB1CB-3661-4EF0-AC32-92BC51E2A743}' INNER JOIN tbl7D907EEE362C4A368BF8C89BBA5ED721 WITH (NOLOCK) ON tbl7D907EEE362C4A368BF8C89BBA5ED721.RecordID = tblXML.ID AND tbl7D907EEE362C4A368BF8C89BBA5ED721.fldE8C953906BB544E48585F5CA4BA6D782 = '{FF83DEC9-5C30-4B77-ACE5-9900AB3EC6B0}' WHERE tblXML.fld1453BEEFA8D64F4CB4285850C8CA2540 IN () AND tblXML.Approved = 1
