declare @B table (Bid int identity, description varchar(50))
declare @P table (Pid int identity, Bid int, description varchar(50))
declare @T table (Tid int identity, description varchar(50))
declare @TinP table (TinPid int identity, Tid int, Pid int)
insert into @B (description) select 'B1'
insert into @B (description) select 'B2'
insert into @P (description, Bid) select 'P1', 1
insert into @P (description, Bid) select 'P2', 1
insert into @P (description, Bid) select 'P3', 2
insert into @T (description) select 'T1'
insert into @T (description) select 'T2'
insert into @T (description) select 'T3'
insert into @TinP (Tid, Pid) select 1, 1
insert into @TinP (Tid, Pid) select 1, 2
insert into @TinP (Tid, Pid) select 2, 2
insert into @TinP (Tid, Pid) select 3, 3
select * from @B
select * from @P
select * from @T
select * from @TinP

select t.*
from @T t
where exists 
(
  select * from @P p
  inner join @TinP tp 
  on tp.Pid=p.Pid and tp.Tid=t.Tid
  where p.Bid = @Bid
)