A                B               A_B_Join
============     ============     ===============
 Id  |  ...       Id  |  ...       A_Id  |  B_Id
------------     ------------     ---------------
  0  |  ...        5  |  ...          0  |  5
  1  |  ...        6  |  ...          0  |  7
  2  |  ...        7  |  ...          1  |  5
  3  |  ...        8  |  ...          1  |  6
                                      2  |  6
     :                :               2  |  7
     :                :               3  |  7
                                      3  |  8
                                      3  |  5

SELECT A.* FROM A INNER JOIN A_B_Join ON A.id=A_B_Join.A_id WHERE A_B_Join.B_Id NOT IN (:BIds)