摘要： select * from T_A a (nolock) where a.xh not in (select xh from T_B) 方法1：效果甚微 select * from T_A a (nolock) where not exists (select xh from T_B where x 阅读全文