关于2表删除的问题

问题：表1
aa bb cc
AA 1 afdf
AA 2 dfa
AA 3 efafe
BB 2 dfa
CC 3 vagd
CC 4 rgdfad
表2
aa bb
AA 2
CC 4

aa,bb为主键，当表2出现时，删除表1的相应行，操作后表1为
aa bb cc
AA 1 afdf
AA 3 efafe
BB 2 dfa
CC 3 vagd 

 

create table #tab1(aa varchar(2),bb int,cc varchar(10))
insert into #tab1 values('AA',1,'afdf')
insert into #tab1 values('AA',2,'dfa')
insert into #tab1 values('AA',3,'efafe')
insert into #tab1 values('BB',2,'dfa')
insert into #tab1 values('CC',3,'vagd')
insert into #tab1 values('CC',4,'rgdfad')

create table #tab2(aa varchar(2),bb int)
INSERT INTO #TAB2 VALUES('AA',2)
INSERT INTO #TAB2 VALUES('CC',4)

delete  #tab1 from #tab1 a where exists (select 1 from #tab2 where aa=a.aa and bb=a.bb)

aa   bb          cc
---- ----------- ----------
AA   1           afdf
AA   3           efafe
BB   2           dfa
CC   3           vagd