CREATE TABLE A
(
ID integer
);
CREATE TABLE B
(
  ID integer
);
CREATE TABLE AB
(
  AID integer,
  BID integer
);

INSERT INTO A VALUES (1),(2),(3);
INSERT INTO B VALUES (4),(5),(6);
INSERT INTO AB VALUES (1,5),(1,6),(3,4);

/*************      SELECT WORKS       *************

SELECT B.*
  FROM B INNER JOIN AB ON AB.BID = B.ID INNER JOIN A ON AB.AID = A.ID WHERE A.ID = 1*/