DECLARE @A TABLE (Aid VARCHAR(5), Aname VARCHAR(10))
INSERT @A (Aid, Aname) VALUES
('Aid1', 'Aname1'),
('Aid2', 'Aname2'),
('Aid3', 'Aname3'),
('Aid4', 'Aname4'),
('Aid5', 'Aname5')

DECLARE @B TABLE (Bid VARCHAR(5), Bname VARCHAR(10))
INSERT @B (Bid, Bname) VALUES
('Bid1', 'Bname1'),
('Bid2', 'Bname2'),
('Bid3', 'Bname3'),
('Bid4', 'Bname4'),
('Bid5', 'Bname5')

DECLARE @AB TABLE (Aid VARCHAR(5), Bid VARCHAR(5))
INSERT @AB (Aid, Bid) VALUES
('Aid1', 'Bid2'),
('Aid2', 'Bid2'),
('Aid2', 'Bid3'),
('Aid2', 'Bid4'),
('Aid2', 'Bid5'),
('Aid3', 'Bid2'),
('Aid3', 'Bid4'),
('Aid4', 'Bid1'),
('Aid5', 'Bid2'),
('Aid5', 'Bid3'),
('Aid5', 'Bid4 ')




SELECT 
    AB.Aid
FROM 
    @A AS A
INNER JOIN
    @AB AS AB
    ON A.Aid = AB.Aid
WHERE
    AB.Bid IN ('Bid2', 'Bid3', 'Bid4')
GROUP BY
     AB.Aid
HAVING COUNT(*) = (SELECT COUNT(*) FROM @B WHERE Bid IN ('Bid2', 'Bid3', 'Bid4'))