insert into 怎么不重复数据

insert into 如何不重复数据
现有两表
表a
  mid 门店
1aa
2bb
3cc
4dd
5ee
6ff
7gg
8hh

表b
  mid 门店
1aa
2bb
3cc
7gg
8hh
9ii
10jj
11kk
现从表b向表a添加数据.请问如何不会重复添加
想要的结果:
表a
  mid 门店
1aa
2bb
3cc
4dd
5ee
6ff
7gg
8hh
9ii
10jj
11kk


[解决办法]

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*/