那改成这样试试:insert into bm_setspbm select recordid=2,spbm,rkbz,salebz,excutesalebz,excuterkbz,ztrq,userid
from bm_setspbm
where recordid=1 And spbm Not IN(Select spbm from bm_setspbm Where recordid=2)
from bm_setspbm
where recordid=1 And spbm Not IN(Select spbm from bm_setspbm Where recordid=2)
无论你怎么排除相同的!!!