前提是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)
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)
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)
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)
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)
(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 )
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)