Contact   |   Facility_Contact   |   Facility   |   Bank
          |                      |              |
ID        |   (fk) Contact_ID    |      ID      |   ID
CName     |   (fk) Facility_ID   |    FName     |   BName
          |                      |    BNumber   |   BNumber

CName | FName | BName

SELECT
  HUD.[HOLDER NAME], Facility.PROVNAME, Contact.LAST_NAME

FROM
  Facility INNER JOIN Bank ON Facility.[BNumber] = HUD.[BNumber]) INNER JOIN
  (Contact INNER JOIN Facility_Contact ON Contact.[ID] = Facility_Contact.[Contact_ID]) ON Facility.[ID] = Facility_Contact.[Facility_ID];