现有两表
表a
mid 门店
1 aa
2 bb
3 cc
4 dd
5 ee
6 ff
7 gg
8 hh
表b
mid 门店
1 aa
2 bb
3 cc
7 gg
8 hh
9 ii
10 jj
11 kk
现从表b向表a添加数据.请问如何不会重复添加
想要的结果:
表a
mid 门店
1 aa
2 bb
3 cc
4 dd
5 ee
6 ff
7 gg
8 hh
9 ii
10 jj
11 kk
------解决方案--------------------
- SQL code
--tryinsert into a select * from b where mid not in (select mid from a)
------解决方案--------------------
- SQL code
--> 测试数据: #aif object_id('tempdb.dbo.#a') is not null drop table #acreate table #a (mid int,门店 varchar(2))insert into #aselect 1,'aa' union allselect 2,'bb' union allselect 3,'cc' union allselect 4,'dd' union allselect 5,'ee' union allselect 6,'ff' union allselect 7,'gg' union allselect 8,'hh'--> 测试数据: #bif object_id('tempdb.dbo.#b') is not null drop table #bcreate table #b (mid int,门店 varchar(2))insert into #bselect 1,'aa' union allselect 2,'bb' union allselect 3,'cc' union allselect 7,'gg' union allselect 8,'hh' union allselect 9,'ii' union allselect 10,'jj' union allselect 11,'kk';-->如果门店不重复insert into #a select * from #b where not exists (select 1 from #a where 门店=#b.门店)select * from #a/*mid 门店----------- ----1 aa2 bb3 cc4 dd5 ee6 ff7 gg8 hh9 ii10 jj11 kk*/