while exists (select * from shuju as A where A.cname not in (select distinct cname from mainnew)) insert into mainnew (cname,tel,fax,zip,) select top 1 cname,tel,fax,zip from shuju as A where A.cname not in (select distinct cname from mainnew)
insert into mainnew('a','b','c','d') where 'a' not in(select cname from mainnew)
where A.cname not in (select distinct cname from mainnew))
insert into mainnew (cname,tel,fax,zip,)
select top 1 cname,tel,fax,zip from shuju as A
where A.cname not in (select distinct cname from mainnew)
where 'a' not in(select cname from mainnew)
我是说表shuju中cname的不能在表mainnew中有了,不知道有没有说清楚,说个离子
如果要插入的CNAME的直为"万向通信有限公司 ",mainnew中的cname不能含有
"万向通信有限公司 ",
select cname,tel,fax,zip from shuju where cname not in (select cname from mainnew)
select cname,tel,fax,zip from shuju
where cname not in (select cname from mainnew)