title: Full Text Search On Relational Tables?
body: <p>I have an sql server database that has multiple tables that are all related to each other.</p>
  <p>I am wondering is it possible to use FreeTextTable or ContainsTable for this?</p>
  <p>I have only seen examples of looking at one table and search all the columns. I have not seen a case where I may have say a form. Lets call it &quot;student application form&quot;.</p>
  <p>On this form it may have information like</p>
  <ul>
  <li>Student First Name</li>
  <li>Student Last Name</li>
  <li>Address</li>
  <li>Campus they wish to study at</li>
  <li>Tell us about yourself</li>
  </ul>
  <p>Now I want to build 1 search box that will search all these tables and find this &quot;application&quot;</p>
  <p>the user might type in</p>
  <p>John Smith
  Main Campus
  motivated</p>
  <p>So all tables and columns would need to be checked, but end result would be brining back the application(s) that the full text search thinks matches what was typed in.</p>
  <p>The table structure might be like this</p>
  <p>Application</p>
  <ul>
  <li>id</li>
  <li>firstName</li>
  <li>lastName</li>
  <li>campusId</li>
  <li>AddressId</li>
  </ul>
  <p>Campus</p>
  <ul>
  <li>id</li>
  <li>name</li>
  </ul>
  <p>Address</p>
  <ul>
  <li>id
  -Name</li>
  </ul>
  <p>In my real database I got like 5 or 6 tables that join with the &quot;application&quot; table and would all need to be accounted for.</p>
  <p>Can this be done with full text search? Or do I have to search each table individually and somehow tie it all together again.</p>