SELECT FT_TBL.*
     , tblLocation.*
     , tblType.*
     , tblCategory.*
     , tblAgency.* 
     , FT_TBL.Vacancy_Title
     , FT_TBL.Vacancy_Description
     , KEY_TBL.RANK
FROM tblAgency 
INNER JOIN (tblLocation 
  INNER JOIN (tblType 
    INNER JOIN (tblCategory 
      INNER JOIN (tblVacancy AS FT_TBL 
        INNER JOIN FREETEXTTABLE(tblVacancy
                , Vacancy_Title, "test") AS KEY_TBL  
           ON FT_TBL.Vacancy_ID 
            = KEY_TBL.[KEY])
          ON tblCategory.Category_ID 
          = FT_TBL.Vacancy_CatID) 
       ON tblType.Type_ID 
        = FT_TBL.Vacancy_TypeID)
     ON tblLocation.Location_ID 
      = FT_TBL.Vacancy_LocationID)
   ON tblAgency.Agency_ID 
    = FT_TBL.Vacancy_AgencyID