SELECT DISTINCT * FROM А WHERE EXISTS (SELECT * FROM Б WHERE EXISTS (SELECT * FROM С WHERE С.А_ID = Б.A_ID) AND Б.А_ID = А.А_ID)