INSERT INTO duldphdcx(f10,f14,f15)
SELECT DISTINCT f13,f12,f11 from du4hdcx
where f13 not in(select f10,f14,f15 from duldphdcx) and
f12 not in(select f10,f14,f15 from duldphdcx) and
f11 not in(select f10,f14,f15 from duldphdcx)
INSERT INTO du1dphdcx
(f10,f14,f15)
SELECT DISTINCT f13,f12,f11
FROM du4hdcx
WHERE not exists
(SELECT f10,f14,f15
FROM du1dphdcx where f13= f10 and f12 =f14 and f11 = f15 )
INSERT INTO du1dphdcx (f10,f14,f15)
SELECT DISTINCT f13,f12,f11 FROM du4hdcx
WHERE cast(f13 as char)+cast(f12 as char)+cast(f11 as char) NOT IN (SELECT cast(f10 as char)+cast(f14 as char)+cast(f15 as char) FROM du1dphdcx)
前提是f13,f12,f11,f10,f14,f15都是字符串,如果不是自己加上转换类型函数
INSERT INTO du1dphdcx (f10,f14,f15)
SELECT DISTINCT f13,f12,f11 FROM du4hdcx
WHERE f13+f12+f11 NOT IN (SELECT f10+f14+f15 FROM du1dphdcx)
前提是f13,f12,f11,f10,f14,f15都是字符串,如果不是自己加上转换类型函数
INSERT INTO du1dphdcx (f10,f14,f15)
SELECT DISTINCT f13,f12,f11 FROM du4hdcx
WHERE f13+f12+f11 NOT IN (SELECT f10+f14+f15 FROM du1dphdcx)
前提是f13,f23,f11,f10,f14,f15都是字符串,如果不是自己加上转换类型函数
INSERT INTO du1dphdcx (f10,f14,f15)
SELECT DISTINCT f13,f12,f11 FROM du4hdcx
WHERE f13+f12+f11 NOT IN (SELECT f10+f14+f15 FROM du1dphdcx)