title: Select the field that ever fulfil condition
body: <p>Employee Table</p>
  
  <pre><code> NameId  Name
   1       Andy
   2       Peter
   3       Jason
   4       Thomas
   5       Clark
  </code></pre>
  
  <p>Employee - Supervisor Relations</p>
  
  <pre><code>NameId  SupervisorId (Refer to employee Id)
  1       4
  1       2
  2       3
  5       4
  </code></pre>
  
  <p>How can i select query to return search with all name that supervisor 'once' to be Thomas. So the result i want is like this.</p>
  
  <pre><code>Name  Supervisor
  Andy  Thomas       
  Andy  Peter (Is valid because Andy supervisor contains 'Thomas')
  Clark Thomas
  </code></pre>