--1 --把A表中不属于B的记录提取出来保存为另外一个表C,然后添加进B表 select a.* from a where xhid not in (select xhid from b) copy to c--保存C表 close all clea all use b appe from c --把A表中不属于B的记录添加到B表的结尾--直接把A表中不属于B的记录添加到B表的结尾 insert into B select a.* from a where xhid not in (select xhid from b)--2.如何查询B表中的XHID中没有重复记录。 --查xhid有重复的. select xhid from b group by xhid having count(*) > 1 select b.* from b where xhid in (select xhid from b group by xhid having count(*) > 1) --查xhid没有重复的. select xhid from b group by xhid having count(*) = 1 select b.* from b where xhid in (select xhid from b group by xhid having count(*) = 1)
--1
--把A表中不属于B的记录提取出来保存为另外一个表C,然后添加进B表
select a.* from a where xhid not in (select xhid from b)
copy to c--保存C表
close all
clea all
use b
appe from c --把A表中不属于B的记录添加到B表的结尾--直接把A表中不属于B的记录添加到B表的结尾
insert into B select a.* from a where xhid not in (select xhid from b)--2.如何查询B表中的XHID中没有重复记录。
--查xhid有重复的.
select xhid from b group by xhid having count(*) > 1
select b.* from b where xhid in (select xhid from b group by xhid having count(*) > 1)
--查xhid没有重复的.
select xhid from b group by xhid having count(*) = 1
select b.* from b where xhid in (select xhid from b group by xhid having count(*) = 1)