我想选择是在第一个表中，但不是在第二个表中的记录，并使用VBA SQL语句将其插入到第二个表。我已经开始在下面，但我不知道为什么它不会工作。我是比较新为sql所以任何帮助将不胜AP preciated。

  MySQL的=INSERT INTO客户端（）＆放大器; _
    SELECT DISTINCT DD [客户ID]。＆放大器; _
    FROM＆安培; tableName值和放大器; 作为DD＆放大器; _
    哪里DD [客户ID] NOT IN（SELECT DD [客户ID] FROM。＆放大器; tableName值和放大器;为DD）
 

解决方案

首先，您需要提供字段列表中插入语句：

  INSERT INTO客户端（客户端ID）...
 

二，查询不插入任何行，因为你检查客户端ID presence在同一个表。您的意思是像成才下一：

 ，其中DD [客户ID] NOT IN（SELECT DD2 [客户ID] FROM。＆放大器; tableName2和放大器;为DD2）
 

I am trying to select records that are in the first table but not in the second table and insert them into the second table using a sql statement in VBA. I have started it below but I am not sure why it won't work. I am rather new to sql so any help would be greatly appreciated.

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

First, you need supply field list to insert statement:

INSERT INTO Clients (ClientID)...

Second, your query doesn't insert any rows, because you check ClientID presence in same table. Did you mean someting like next:

"Where DD.[Client ID] NOT IN (SELECT DD2.[Client ID] FROM " & tableName2 & " as DD2)"