sql exists (函数) 是否存在

select *  from A a where exists (select 1          from B b         where b.id = a.id           and b.name = 'dennybruce');

?