作成 INSERT INTO "temp.db"(卡号, 消费日期, 存入金额, 消费金额) SELECT 卡号, 消费日期, 存入金额, 消费金额 FROM "posqd.DB" as D WHERE 卡号 in (select 卡号 from "pospz.db" where 卡号=D.卡号 AND 消费日期=D.消费日期 AND 消费金额= D.消费金额 AND 存入金额= D.存入金额)要加快速度的话要检索引
INSERT INTO "temp.db"(卡号, 消费日期, 存入金额, 消费金额) as SELECT 卡号, 消费日期, 存入金额, 消费金额 FROM "posqd.DB" as D WHERE (select 卡号, 消费日期, 存入金额, 消费金额 from "pospz.db" where 卡号=D.卡号 AND 消费日期=D.消费日期 AND 消费金额= D.消费金额 AND 存入金额= D.存入金额)
INSERT INTO "temp.db"(卡号, 消费日期, 存入金额, 消费金额) as SELECT D.卡号, D.消费日期,D.存入金额, D.消费金额 FROM "posqd.DB" as D,"pospz.db" as G WHERE G.卡号=D.卡号 AND G.消费日期=D.消费日期 AND G.消费金额= D.消费金额 AND G.存入金额= D.存入金额
INSERT INTO "TEMP.DB" (卡号,消费日期,存入金额,消费金额) SELECT 卡号, 消费日期, 存入金额, 消费金额 FROM "POSQD.DB" AS D WHERE EXISTS( SELECT 卡号, 消费日期, 存入金额, 消费金额 FROM "POSPZ.DB" WHERE 卡号=D.卡号 AND 消费日期=D.消费日期 AND 消费金额= D.消费金额 AND 存入金额= D.存入金额)
INSERT INTO "temp.db"(卡号, 消费日期, 存入金额, 消费金额)
SELECT 卡号, 消费日期, 存入金额, 消费金额
FROM "posqd.DB" as D
WHERE
卡号 in
(select 卡号 from "pospz.db"
where 卡号=D.卡号 AND 消费日期=D.消费日期
AND 消费金额= D.消费金额 AND 存入金额= D.存入金额)要加快速度的话要检索引
as SELECT 卡号, 消费日期, 存入金额, 消费金额
FROM "posqd.DB" as D
WHERE
(select 卡号, 消费日期, 存入金额, 消费金额 from "pospz.db"
where 卡号=D.卡号 AND 消费日期=D.消费日期
AND 消费金额= D.消费金额 AND 存入金额= D.存入金额)
as SELECT D.卡号, D.消费日期,D.存入金额, D.消费金额
FROM "posqd.DB" as D,"pospz.db" as G
WHERE G.卡号=D.卡号 AND G.消费日期=D.消费日期
AND G.消费金额= D.消费金额 AND G.存入金额= D.存入金额
INSERT INTO "TEMP.DB" (卡号,消费日期,存入金额,消费金额)
SELECT 卡号, 消费日期, 存入金额, 消费金额
FROM "POSQD.DB" AS D
WHERE EXISTS(
SELECT 卡号, 消费日期, 存入金额, 消费金额
FROM "POSPZ.DB"
WHERE 卡号=D.卡号 AND 消费日期=D.消费日期 AND
消费金额= D.消费金额 AND 存入金额= D.存入金额)