access 追加查询

insert into ordercount(orderid,userid,realname,paytype,deltype,state,costs,phone,address,postcode,remark,ordertime)
select dingdan,orderid,realname,paytype,deltype,zhuangtai,zonger,usertel,shouhuodizhi,youbian,liuyan,orderdate from orders where
id in(select a.id   from (select id,dingdan from orders where dingdan>'')   a left join (select id,dingdan from orders where dingdan>'')  b on a.dingdan=b.dingdan and a.id>b.id  where b.dingdan is null)