sql not in 和 not exists （执行效率高）

 not exists：（执行效率高）

select * from test2
 where not exists 
( select 1 from test1 where test1.object_name = test2.table_name and test1.object_name like 'A%') ;

not in

 select * from test2
  where table_name not in 
  ( select object_name from test1 where object_name like 'A%') ;