帮忙看看这个PLSQL是否有错？

Question

where 条件要指明哪个字段NOT EXISTS

Answer 1

INSERT INTO  "PLAN1" ("BH","D01","D02","RQ")
        SELECT
          "JH_B2_203_S"."BH",
          "JH_B2_203_S"."D01",
          "JH_B2_203_S"."D02",
          "JH_B2_203_S"."RQ"
        FROM
          "JH_B2_203"@"S" "JH_B2_203_S"
        WHERE
          NOT EXISTS(
SELECT "PLAN1"."RQ" FROM "PLAN1" WHERE "PLAN1"."RQ"="JH_B2_203_S"."RQ" AND "PLAN1"."BH"="JH_B2_203_S"."BH")）;试试看！

Answer 2

错了！要
INSERT INTO  "PLAN1" ("BH","D01","D02","RQ")
        (SELECT
          "JH_B2_203_S"."BH",
          "JH_B2_203_S"."D01",
          "JH_B2_203_S"."D02",
          "JH_B2_203_S"."RQ"
        FROM
          "JH_B2_203"@"S" "JH_B2_203_S"
        WHERE
          NOT EXISTS(
SELECT "PLAN1"."RQ" FROM "PLAN1" WHERE "PLAN1"."RQ"="JH_B2_203_S"."RQ" AND "PLAN1"."BH"="JH_B2_203_S"."BH"));

Answer 3

你贴的这一句没错误呀，看错误提示你是不是提交时
exists 误写成了 exitsts