SQL语句中的语法错误（2）

Question

我想在VBA宏中运行这条SQL语句，但由于某种原因，由于语法错误，我无法找到它，所以它不会运行。我对VBA相当陌生，所以任何帮助指出这个错误将不胜感激。

Dim dte As String, db As Database, tableName As String, DataDump As Recordset, clientTable As Recordset 
Set db = CurrentDb 
dte = InputBox("What date was the Data Dump run?", "Please Input a date") 
tableName = "FN_DataDump_ALL_" & dte 
Set DataDump = db.OpenRecordset(tableName, dbOpenDynaset, dbEditAdd) 
Set clientTable = db.OpenRecordset("Clients", dbOpenDynaset, dbEditAdd) 

MySQL = "SELECT DISTINCT DD.[Client ID] " & _ 
     "INTO Clients " & _ 
     "FROM " & tableName & "as DD " & _ 
     "Where CL.[Client ID] NOT IN (SELECT DD.[Client ID] ""FROM"" & tableName & ""as DD"") " 

db.Execute MySQL 

Answer 1

错位引号FROM，而遗漏的空间产生TABLENAMEAS，而不是：

= "SELECT DISTINCT DD.[Client ID] " & _ 
     "INTO Clients " & _ 
     "FROM " & tableName & " as DD " & _ 
     "Where CL.[Client ID] NOT IN (SELECT DD.[Client ID] FROM " & tableName & " as DD)"