博客园站长
这是人类成长进步中记录的每一时刻
select id, name
  from TAB_A t
 where not exists (select 1
          from TAB_B t1
         where t.id = t1.id
           and t.name = t1.name)

  

posted on 2014-11-24 10:57  dm3344  阅读(1933)  评论(0编辑  收藏  举报