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