declare @a table ( col char(1) )
declare @b table ( col char(1) )

insert	@a
select 'a' union all
select 'b' union all
select 'c' union all
select 'd'

insert	@b
select 'a' union all
select 'a' union all
select 'b' union all
select 'b' union all
select 'b' union all
select 'c' 

select * from @a a inner join @b b on a.col = b.col
select * from @a a where exists( select * from @b b where a.col = b.col )

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass