sql - 带有 where 条件的插入语句抛出错误

Question

以下 SQL 语句在 Oracle 中抛出错误:

INSERT INTO TABLE1 (ACCT_NB, ACCT_TYPE, TOKEN_ID)
SELECT ACCT_NB, 'A', ID FROM TABLE2
WHERE NOT IN (SELECT ACCT_NB FROM TABLE1 
              WHERE ACCT_TYPE='A' AND TABLE1.ACCT_NB=TABLE2.ACCT_NB)

SQL 命令未正确结束。请帮助更正查询

Answer 1

您缺少 not in 运算符的左侧。我假设它应该是 ACCT_NB:

INSERT INTO TABLE1 (ACCT_NB, ACCT_TYPE, TOKEN_ID)
SELECT ACCT_NB, 'A', ID 
FROM   TABLE2
WHERE  ACCT_NB NOT IN (SELECT ACCT_NB 
                       FROM   TABLE1 
                       WHERE  ACCT_TYPE='A' AND TABLE1.ACCT_NB=TABLE2.ACCT_NB)