select nameid from A where not exists (
select 1 from B where a.nameid like replace(B.nameid,'*','%'));

------解决方案--------------------
是我没看明白吗？这样写不行吗？
select *  
 from table1 a
  where a.nameid not in (select nameid from table2)

------解决方案--------------------
3楼正解