select count(sfzh),sfzh
from balance.wd_mrsda
where zkrq>='2006-06-25'and klx='H' and kbh is not in ( select kbh from balance.bkjlk )
group by sfzh
having count(sfzh)>1
选出那些卡号不在补卡记录库里的(就是没补过卡的身份证号码却一样的记录)
from balance.wd_mrsda
where zkrq>='2006-06-25'and klx='H' and kbh is not in ( select kbh from balance.bkjlk )
group by sfzh
having count(sfzh)>1
选出那些卡号不在补卡记录库里的(就是没补过卡的身份证号码却一样的记录)
from balance.wd_mrsda
where zkrq>='2006-06-25'and klx='H' and kbh not in ( select kbh from balance.bkjlk )
group by sfzh
having count(sfzh)>1
select count(sfzh),sfzh
from balance.wd_mrsda
where zkrq>='2006-06-25'and klx='H' and kbh not in ( select kbh from balance.bkjlk )
group by sfzh
having count(sfzh)>1
balance.wd_mrsda =>balance.dbo.wd_mrsda
balance.bkjlk =>balance.dbo.bkjlk